Thread: Separate multiple entries in cell to individual cells
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jim15[_8_] Jim15[_8_] is offline
external usenet poster
  
Posts: 1
Default 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

Reply With QuoteReply With Quote