Pulling data from a cell in between /

[mab2819]

Hi,

I need to extract data that is inbetween slashes in a cell. For instance, in
the example below, I need to grab the 377.51 value.

AA7061555555/377.51/20JUL07/F

How can I accomplish this?

TIA,
mab

 

[Bob Phillips]

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

 

[mab2819]

That is SO PRETTY. Thank you!
--
mab

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

--
__________________________________
HTH

Bob