View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Cecilia Cecilia is offline
external usenet poster
 
Posts: 26
Default Finding a numerical value within a cell

I am trying to extract all the characters after a numerical value in a cell.
The numerical value can be any number and at various positions within the
cell. The text after the number varies.

Here are some examples of the cells.

NOVELS 8 FT 7 Shelf
ROMANCE 8 FT 7 Shelf
YR-TEEN 8ft 78in

I've thought of the find, mid, left, right functions but that all require
using a set number to search for or extracting based on a set number of
characters.

Any way to do this?

Any help is appreciated.

Thanks!!