Combining Cells

[Greg B...]

Hi all

I have 2 cell Surname and Firstname and is it possible to write a code to
get both values to combine in 1 cell.

here is an example

A1 Smith

A2 John

then it appears on another worksheet in cell a1 as:

Smith, John

Thanks in advance

Greg

 

[Mike Fogleman]

Put this in A1 of Sheet2 to combine A1 & A2 from Sheet1: =Sheet1!A1&",
"&Sheet1!A2

Mike F

 

[Greg B...]

Thanks Mike never put the & sign

Greg