Thread: how do I extract only certain data from a cell?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Stan in South Africa Stan in South Africa is offline
external usenet poster
  
Posts: 10
Default how do I extract only certain data from a cell?
Office 2003, Win XP Pro.
I am presented with a worksheet containing dozens of cells in which is
contained data of different lengths. eg
Zippohat 52131123Sa011880702
Baker 18164
Renatsainv17247
15592 Inv
Each contains an invoice number, as follows:
18807
18164
17247
15592
These invoice numbers range between 15000 and 20000
Is there any way to extract only the invoice number from each cell.


Reply With QuoteReply With Quote