G Guest Aug 13, 2004 #1 I have one cell with the format Smith, Bill in it. I need to make it Bill Smith. Suggestions
J Jason Morin Aug 13, 2004 #2 =MID(A1,FIND(",",A1)+2,999)&" "&LEFT(A1,FIND(",",A1)-1) HTH Jason Atlanta, GA
G Guest Aug 13, 2004 #3 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?
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?
J Jason Morin Aug 13, 2004 #4 You could run a macro that does this, or you could use an event macro that automatically runs when new info is entered. Jason
You could run a macro that does this, or you could use an event macro that automatically runs when new info is entered. Jason
G Guest Aug 13, 2004 #5 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 Click to expand...
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 Click to expand...
F Frank Kabel Aug 13, 2004 #6 Hi just as another option: Use 'Data - Text to columns' and simply re-arrange the columns afterwards
