Thread: creating last name first, first name last from a column of first name last name data
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Patrick Molloy Patrick Molloy is offline
external usenet poster
  
Posts: 1,049
Default creating last name first, first name last from a column of first name last name data
select the column , use Edit, Find, Replace and in the Find What box type a
space and in the Replace with box type a comma and a space

"JasonK" wrote in message
...


I can't figure for the life of me how the make a column of names
formatted:

FirstName LastName

into

LastName, FirstName


I'm sure there is an easy formula to copy or macro to write.

can someone help me with this?

thanks a ton, in advance. I'm appreciate your help.

JasonK


Reply With QuoteReply With Quote