Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
I need to split a name / last name cell into two different cell.
I have a cell that contains name, last name and middle initial. Is there a
way to automatically split those items into 3 different cells? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
I need to split a name / last name cell into two different cell.
One way:
Data/Text to Columns/Delimited/Space. To automatically do that, you can record a macro. In article , "casinfo" wrote: I have a cell that contains name, last name and middle initial. Is there a way to automatically split those items into 3 different cells? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
I need to split a name / last name cell into two different cell.
You can use the Text To Columns tool on the Data menu.
-- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "casinfo" wrote in message ... I have a cell that contains name, last name and middle initial. Is there a way to automatically split those items into 3 different cells? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
I need to split a name / last name cell into two different cell.
per the response to your first post:
Hi Casinfo, Look at Data | Text To Columns --- Regards, Norman You may need to split last from the remainder first with comma as the separator, then split the resulting second column using space as the separator. Or you could split on space the first time and replace the comma with nothing. -- Regards, Tom Ogilvy "casinfo" wrote in message ... I have a cell that contains name, last name and middle initial. Is there a way to automatically split those items into 3 different cells? |
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 Blank Cell into Two (Without Inserting Cell) | Excel Discussion (Misc queries) | |||
Split a Blank Cell into Two (Without Inserting Cell) | Excel Discussion (Misc queries) | |||
Can unmerged cell contents be split to another cell | Excel Worksheet Functions | |||
How can I split one cell into two cell parts (upper & lower)? | Excel Discussion (Misc queries) |