Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
combining 2 columns of data
hello
my problem is i have a list of names (one column of first names, and one column of last names), my boss says we need to have the first and last names in the same column. Is there any way that the Data can be combined without having to retype all 5000 names?? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
combining 2 columns of data
You can write a formula in a new cell to combine cells. For instance
if the first name is in A1 and the last name is in B1, you can write a formula in C1 like this: =A1&" "&B1 This joins the value of A1 with a space and the value of B1. If you need to you can arrange it to be last name comma first name: =B1&", "&A1 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Inserting a new line when external data changes | Excel Discussion (Misc queries) | |||
how to split data into columns and arrange the resulting data | Excel Discussion (Misc queries) | |||
Convert 1 row of data into Multiple columns | Excel Discussion (Misc queries) | |||
How to take matching data from 2 columns and put in the same row? | New Users to Excel | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions |