View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
DianeD DianeD is offline
external usenet poster
 
Posts: 4
Default Parsing text in a cell

I get a report of our members with the names in one cell. I need to parse to
separate the last name so I can alpha sort. Some names have first, middle,
last, title and some just have first and last. If I create 4 columns, then
those names with 2 parts fall in the wrong fields.
--
Diane