FIND function

  • Thread starter Thread starter Jay
  • Start date Start date
J

Jay

I have a body of text in each cell within a column.
Within the body of text, there is always a reference to
either "0/1", "1/1", "1/2", etc. I know I can use the
find function, combined with the mid function, to extract
the "0/1" or "1/1" if I set up a separate column for each
separate sequence. However, is there a way to just set up
one column to search for "0/1" or "1/1" or "2/3". I think
there are about 9 difference sequences ("1/1, etc.) to
search for.
 
Thanks for the advise. The catch is that some of the
cells also have dates in them, entered as 01/25/2002 for
example. Is there a variation of your formula I can use
to eliminate FIND from catching the dates (ie FIND "
*/* " - although I know you can't use wildcards in FIND).
 
You could count the slashes, if there are only one slash in the ones you
want to extract you could use

=IF(LEN(A1)-LEN(SUBSTITUTE(A1,"/",""))>1,"",MID(A1,FIND("/",A1)-1,3))
 
Back
Top