Combining first and last names

[Lewis Shanks]

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]

=A1&" "&B1

If the first name is in A1 and lastname in B1.