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?

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?

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?

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?