View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dallas PM Dallas PM is offline
external usenet poster
 
Posts: 6
Default Yet Another Name Format Question

I am running Excel 2003 where cell A1 is John Paul Jones. My task is to
reformat the contents of cell A1 to Jones John Paul in cell B1. Due to the
structure of the worksheet, I cannot add columns or use VBA/macros, so the
solution has to be executed in B1. Any assistance will be greatly appreciated.