L
lheck77
If I have, as an example In cell A1 (Henry, Patrick) and I want it to print
on a label Patrick Henry, how can I do that?
on a label Patrick Henry, how can I do that?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
Jason Morin
=RIGHT(A1,LEN(A1)-FIND(", ",A1)-1)&" "&LEFT(A1,FIND
(",",A1)-1)
HTH
Jason
Atlanta, GA
(",",A1)-1)
HTH
Jason
Atlanta, GA
L
lheck77
Thanks Jason, however I must be doing something wrong it did not do anything.
Larry
Larry
L
lheck77
Jason I did get it to work. Not sure what I was doing wrong before. I do
need to know how to reduce the gap between the first and last name. When I
did it it puts quite a gap between the names.
Thanks Larry H
need to know how to reduce the gap between the first and last name. When I
did it it puts quite a gap between the names.
Thanks Larry H
A
Aamir Hashmi
HI
Try this
'=MID(B11,FIND(" ",B11,1)+1,LEN(B11)) & " " & LEFT(B11,FIND(" ",B11))
Aami
Try this
'=MID(B11,FIND(" ",B11,1)+1,LEN(B11)) & " " & LEFT(B11,FIND(" ",B11))
Aami