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