Separate multiple entries in cell to individual cells
 

Anybody have a macro that can either (1) delete a word (in this case
Total) from a cell or (2) separate the number from the word total and
put them in separate cells. Item (2) is more desirable as I can use
this to separate components in a cell.

42357310130000 Total

Thanks,

Jim15


--
Jim15
------------------------------------------------------------------------
Jim15's Profile: http://www.excelforum.com/member.php...o&userid=26300
View this thread: http://www.excelforum.com/showthread...hreadid=467545

Separate multiple entries in cell to individual cells
 

Try DataText to Columns and use the 'space' as your delimiter. Work
really slick!

Good Luck

Bruc

--
swatsp0

-----------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...fo&userid=1510
View this thread: http://www.excelforum.com/showthread.php?threadid=46754