Thread: re-arrange text
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
snugs25
 
Posts: n/a
Default re-arrange text

How can i re-arrange a list of text (which are names) in such a way: for
example changing

Bob Smith
to:
Smith, Bob.

is there an easier way of doing it than manually so that i can apply it to a
large list?

Thanks!
Gem