View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Liz C Liz C is offline
external usenet poster
 
Posts: 12
Default Separate parts of a name into three cells

I have a name cell that has last, first middle. How can I separate the last
into one cell, the first in the next cell and the middle in the next. The
last and first have a , and a space between them and there is a space between
the first and the middle.

Thanks in advance for your help!

Liz