View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Fran[_2_] Fran[_2_] is offline
external usenet poster
 
Posts: 1
Default Transposing contents of a cell

I have an Excel spreadsheet with a column containing general text data in
the format e.g:-

Roberts, M. Tracey

which I want in the format:-

Tracey Roberts

I've managed to separate into 2 cells using the comma as a delimiter but now
want to get rid of the middle inital and fullstop. Any ideas gratefully
received