try this, which adds a space between the two cells' contents

=A1&" "&B1


"kraway" wrote:

I want to merge 2 columns of data into 1 but I want to keep the all the data.
Lets say column A contains "Mr" and column B contains "Jones", I want the
result to be in column C "MR Jones".

Any help?