Can this be done: Mary Smith instead of Smith, Mary? Thanks, Diane
G Guest Oct 21, 2004 #3 I have a list of names: Smith, Mary J. I need to convert to: Mary J. Smith in the same cell. Does that make sense? Thanks, Diane
I have a list of names: Smith, Mary J. I need to convert to: Mary J. Smith in the same cell. Does that make sense? Thanks, Diane
P Paul Corrado Oct 21, 2004 #4 You cannot convert them in the "same cell" without VB and that is probably not necessary. Use the formula on Chip's site in a helper column and then Copy/Paste Special the converted names back over the original data.
You cannot convert them in the "same cell" without VB and that is probably not necessary. Use the formula on Chip's site in a helper column and then Copy/Paste Special the converted names back over the original data.
J JE McGimpsey Oct 21, 2004 #5 One way: =TRIM(MID(A1,FIND(",",A1)+1,255)&" "&LEFT(A1,FIND(",",A1)-1))