I'm trying to get three cells to join without the formula.
example:
B1 - Smith
C1 - John
D1 - Mr

A1 - Mr Smith John

how can I make A1 equal that value without using a formula or with using a
formula and then just keeping the value and getting rid of the formula.

Any help or advice will be greatly appreciated
Thanks in advance