Thread: Switching Text
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Felix Felix is offline
external usenet poster
 
Posts: 78
Default Switching Text

I have a huge list of names in either of the following ways:

PeterSmith or
Peter Smith

Is there an easier way (other than manually switch) to have the list in the
order like

Smith, Peter or at least
Smith Peter ?

The only way I can think of is to somehow recognize the capitals...

Thank you

Felix