Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Combining first and last names
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 |
#2
|
|||
|
|||
=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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|