G
Guest
I have one cell with the format Smith, Bill in it. I need to make it Bill
Smith.
Suggestions
Smith.
Suggestions
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
=MID(A1,FIND(",",A1)+2,999)&" "&LEFT(A1,FIND(",",A1)-1)
HTH
Jason
Atlanta, GA
HTH
Jason
Atlanta, GA
G
Guest
I then have to copy/paste special/values in order for the info to stay in the
cell if I delete the original information.
I have to do this with another formula I use as well. Any other way of
having information applied without having to go through this extra step?
cell if I delete the original information.
I have to do this with another formula I use as well. Any other way of
having information applied without having to go through this extra step?
J
Jason Morin
You could run a macro that does this, or you could use an
event macro that automatically runs when new info is
entered.
Jason
event macro that automatically runs when new info is
entered.
Jason
G
Guest
Thanks, you've been a great help.
Jason Morin said:You could run a macro that does this, or you could use an
event macro that automatically runs when new info is
entered.
Jason
F
Frank Kabel
Hi
just as another option: Use 'Data - Text to columns' and simply
re-arrange the columns afterwards
just as another option: Use 'Data - Text to columns' and simply
re-arrange the columns afterwards