View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Eric Eric is offline
external usenet poster
 
Posts: 1,670
Default How to get the value from string?

There is text Apple Computers & Components (17704) in Cell A1, and I would
like to separate Text Apple Computers & Components in Cell B1, and to
separate number 17704 in Cell C1. The size of text and number can be any
length, does anyone have any suggestions?
Thanks in advance for any suggestions
Eric