Home |
Search |
Today's Posts |
#1
|
|||
|
|||
IF function?
In column A I have a list of full names (first and last names). How can
I break up the full names so that the first names appear in column B and the last names appear in column C? |
#2
|
|||
|
|||
Make sure B is empty, select A, do datatext to columns delimited, select
the delimiter maybe space or comma (whatever that separates the names), then click finish. This will give you the first names in A and the last names in B, if you want to keep the original column just make a copy and put in B, the follow the instructions from above -- Regards, Peo Sjoblom (No private emails please) wrote in message ups.com... In column A I have a list of full names (first and last names). How can I break up the full names so that the first names appear in column B and the last names appear in column C? |
#3
|
|||
|
|||
That worked! Thanks
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date & Time | New Users to Excel | |||
Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
clock | Excel Worksheet Functions | |||
Need a ISWorkday Function -- Any Ideas | Excel Worksheet Functions | |||
Conversion | Excel Worksheet Functions |