FIND function

[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.

 

[Vasant Nanavati]

=MID(A1,FIND("/",A1)-1,3)

 

[Jay]

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).

 

[Peo Sjoblom]

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))