View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Stunn Stunn is offline
external usenet poster
 
Posts: 7
Default Need to extract text between numbers in a string

This gets close:

in A5:

=MID($A$1,1,MATCH(TRUE,INDEX(ISNUMBER(-MID($A$1,ROW(OFFSET($1:$1,1,,LEN($A$1))),1)),),0)-1)

in A6:

=MID($A$1,SUM(INDEX(LEN(A$5:A5),))+1,IFERROR(MATCH (TRUE,INDEX(ISNUMBER(-MID($A$1,ROW(OFFSET($1:$1,SUM(INDEX(LEN(A$5:A5),)) +2,,LEN($A$1))),1)),),0),999))

Copied downward through to A15. It leaves a blank cell before every 2 digit number, but correcting this could require a much longer formula.

Steve D.