Jun 21, 2017 07:26 AM
Help! How do I combine first name (column 1) and last names (column 2) in a 3rd column?
Jun 21, 2017 08:00 AM
hi,
you can creat a formula type field, and then use one of the following formulas:
CONCATENATE(NAME, " ", SURNAME) -> Output will be “Klaus Becker”
CONCATENATE(SURNAME, ", " , NAME) -> Output will be “Becker, Klaus”
Jun 21, 2017 08:09 AM
Thanks Klaus, I’ll try that. Victor
Jun 21, 2017 08:14 AM
Does not work as formulated. Help!
Jun 21, 2017 08:29 AM
My sincere apology and thanks. It does work. I at first included ‘->’; you can tell - i am a newbie. Thanks & God Bless! Victor
Jul 06, 2017 04:57 AM
you’re welcome, sorry, I don’t visit this too often.
