Thread: format text
View Single Post
  #2   Report Post  
Mike
 
Posts: n/a
Default

in the next column do
=concatenate(Lastnamecell,", ",Firstnamecell)

"VDan" wrote:

Hi,
I have a list of names in excel that is currently listed Firstname Lastname.
I need it to be listed Lastname, Firstname.
Is there a way to do this?