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?