View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Will Tyson Will Tyson is offline
external usenet poster
 
Posts: 2
Default VB function to reorder names?

thanks for the tips and web links everyone!

they were very helpful!



On 2004-05-21 17:02:31 -0600, "Rob van Gelder"
said:

There's probably an easier way, but here's something that may work:

=TRIM(MID(A1, FIND(",", A1, 1) + 1, LEN(A1))) & " " & MID(A1, 1, FIND(",",
A1, 1) - 1)