|You could use the =CONCATENATE() function or the & symbol to combine text.|
So with Johan in cell A1 in cell B1 you could do something like:
just make sure you put a SPACE character before the name Smith,
else the two names will be pushed together.
A shorter version using the & symbol would be
If you wish to keep the names you have created,
you will need to do a Copy / Paste / Values on column B,
because as they are now, they are simply formulas, not names,