=A1&" "&B1
If the first name is in A1 and lastname in B1.
Lewis Shanks wrote:
I have been presented with a data base in .txt format which has first and
last name in two respective columns. I need to combine them so that they are
in the same column with a space between the first and last name - this
column to be called Contact.
Can anyone advise me how to do this?
Thanks
Lewis Shanks
--
Dave Peterson
|