I have 2 character columns that I want to concatenate into a third column and
then I need to get rid of the first 2 columns (without losing the text) e.g.
A1=Part No 5555/tool
B1=Brand=Vise-Grip
I need: [Part No 5555/tool Brand=Vise-Grip] NOT [=A1&" "&B1]
Is this possible???