Combining Cells-write a code to get both values

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

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

Mike F
"Greg B..." <gregslaptop@ihug.com.au> wrote in message
news:cvsmft$br1$1@lust.ihug.co.nz...
> 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
>

Thanks Mike never put the & sign

Greg