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

=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