View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jim Sigurdson
 
Posts: n/a
Default Resorting full names

I need to resort names in a cell from John & Jane Doe to Doe, John & Jane.

The formulas discussed in previous threads work if there are just a first
and last name in the cell, but not if there are several names as above. Does
anyone have a formula that will work? Thanks.