View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Angel Eyes Angel Eyes is offline
external usenet poster
 
Posts: 1
Default swop round data in a cell

I have a list of names, surname followed by the christiam name in one cell,
EG; Smith, Tom. Is there a way of highlighting all cells in this format so
that they are then displayed as christian name followed by surname.