Excel 97 SR-2: combining/merging data in cells

[jleon]

To any excel Gurus out there:

I have column A with data, let's just say first names. And column B data filled with last names. Is there a way to combine the 2 data into 1 column that is first name and last name?

Any help would be appreciated. thanx

 

[RayH]

In a new column create a formula:

=A1&" "&B1

or

=concatenate(A1," ",B1)

Afterwards you can get a new column of just values by copying the entire column of formulas and doing a Paste Special as values.

 

[jleon]

thanx Ray!!