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

 

[Workin']

That's an easy one. Look up "concatenate" in the Excel help system. It'll walk you right through your problem.

 

[(M)]

Like Workin' sez:

A | B | C
Joe | Smith | =concatenate(B1,&quot;, &quot;,A1) <- added a comma in between


OUTPUT:
A | B | C
Joe | Smith | Smith, Joe