Thread: format text
View Single Post
  #3   Report Post  
VDan
 
Posts: n/a
Default

Both names are in the same cell.

"Mike" wrote:

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?