View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pomona Pomona is offline
external usenet poster
 
Posts: 1
Default Extract multiple numbers from a cell

Here are some examples of text with multiple numbers embedded:
A1 = 3031 // 2841;1886-ring road location
A2 = 3305 //1455-historical
A3 = //3491;3492
A4 = //inactive location; historical = 1790; enter new locaion

Result should be:
B1 = 3031;2841;1886
B2 = 3305;1455
B3 = 3491;3492
B4 = 1790