Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Split cell
Hi All
I have a list of names which includes the Surname and First Name (with a space in the middle). Is it possible to split the list into two (one column for the first name and one for the Surname). As you would expect the names are all different lengths so I guess to need a command to split where ever there is a space. Any help greatly appreciated Kind regards Rexmann (using excel 2002) |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Split cell
Insert enough extra columns to the right of the name to accommodate the break
out of your name field. It may be safer to copy them into a blank worksheet and work on them there. Select the names and from the Menu Bar choose Data and then Text to Columns.... The Convert Text to Columns Wizard will open. The wizard is easy to follow. Choose Delimited in step one and Space in step two. Using spaces as a delimiter usually means you have to do a little extra clean up work to fix people with multiple first or last names. "rexmann" wrote: Hi All I have a list of names which includes the Surname and First Name (with a space in the middle). Is it possible to split the list into two (one column for the first name and one for the Surname). As you would expect the names are all different lengths so I guess to need a command to split where ever there is a space. Any help greatly appreciated Kind regards Rexmann (using excel 2002) |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Split cell
Hi Rexmann,
Select all of your data then goto DataText to Columns. In the wizard select delimited then next then choose space as the delimiter and Finish. HTH Martin |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Split cell
Hi both
Thank you, worked perfect and saved me a lot of time Cheers Rexmann "MartinW" wrote: Hi Rexmann, Select all of your data then goto DataText to Columns. In the wizard select delimited then next then choose space as the delimiter and Finish. HTH Martin |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
split a cell diagonally in excell - a calendar -2 dates in 1 cell | Excel Discussion (Misc queries) | |||
Split a cell | Excel Discussion (Misc queries) | |||
Split cell help! | Excel Discussion (Misc queries) | |||
How can I split one cell into two cell parts (upper & lower)? | Excel Discussion (Misc queries) | |||
Is there a way I can split last name first name in one cell | Excel Discussion (Misc queries) |