Combining Cells-write a code to get both values

[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..." <[email protected]> wrote in message
news:[email protected]...
> 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
>

[Greg B...]

Thanks Mike never put the & sign

Greg