Thread: How do I reverse name order from Last, First to First Last in Exc
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student
 
Posts: n/a
Default How do I reverse name order from Last, First to First Last in Exc
=MID(A1 & " " & A1,FIND(" ",A1,1),LEN(A1))
--
Gary's Student


"Annie Lord" wrote:

I received a file from an outside vendor with names listed Last, First. I
need to print labels for mailing from this file with names First Last. Is
there a way to reverse the order in an Excel spreadsheet?
Reply With QuoteReply With Quote