splitting info in a cell

D

Donna

I have one cell with the format Smith, Bill in it. I need to make it Bill
Smith.

Suggestions
 
D

Donna

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

You could run a macro that does this, or you could use an
event macro that automatically runs when new info is
entered.

Jason
 
D

Donna

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

Hi
just as another option: Use 'Data - Text to columns' and simply
re-arrange the columns afterwards
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

counting repeats. 8
Delete all data after a symbol in a field 0
Auto Fill Word Documents 4
SUMPRODUCT formula I think w/ wild card & number vs number as text 8
Creating Forms 0
Split cells next to 1 cell 1
Can cells be split ? 5
How do I extract data into two cells? 5

Top