If I have a couple thousand contact records in excel with columns with values of "First Name", "Last Name", and "Title" how could I combine those values into a column called "Contact" in the same row?
Microsoft Excel 2007
First create a new column, in that use the
This function basically sticks words togther, so if you've got "Mr", "John" and "Smith" in
This is easy to fix by adding extra spacers to the formula, to get "Mr John Smith".
Now just copy this down the rows, do a paste special to values, and you can delete the original columns.
Use string concatenation. you will need to add spaces, too.
Assuming your current cells are A1:A5, make A6 be
Another way to do it, if you have multiple rows you want to copy:
It should copy all rows into one cell.