Thread: Change data in a single column from "last, first" to "first last"
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
BigPig
 
Posts: n/a
Default Change data in a single column from "last, first" to "first last"
H Jeanne,

If you Names are in Column A, and the last and first are separated by a ","
then:
In column B, you could put:
=MID(A1,FIND(",",A1)+2,LEN(A1)-(FIND(",",A1)+1))

Hope this helps.


Reply With QuoteReply With Quote