Thread: Easy one...
View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
 
Posts: 3,268
Default Easy one...

Why do you assume this is easy?


--
Regards,

Peo Sjoblom



"NWO" wrote in message
...
Ok, I have a list of names in the fomrat John A Doe, Joan Bennett, etc (no
commas, some have middle initial, some don't). How do I get Doe John A,
and
Bennett Joan (last name first name middle initial - commas OK) I tried
the
Pearson example, but it had commas and the last name was first, so it
didn't
work for my problem.

Thank you.

NWO Mark