How to combine two words in different cells?

[thingstodo123]

Hi all,

I am looking for a way to combine a surname in column C with a first name in column B with the results (the whole name) ending up in either column D or A.

I hope that makes sense.

As always any help is greatly appreciated.

Cheers

[simeon.hruby]

thingstodo123,

Try

Please Login or Register  to view this content.

in whatever cell you want the name to appear in i.e. (A1 or D1)


Simeon

[thingstodo123]

Great stuff, thanks a lot

[simeon.hruby]

No problem!