Pulling data from a cell in between /
That is SO PRETTY. Thank you!
--
mab
"Bob Phillips" wrote:
=--MID(A1,FIND("/",A1)+1,FIND("/",A1,FIND("/",A1)+1)-FIND("/",A1)-1)
--
__________________________________
HTH
Bob
"mab2819" wrote in message
...
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
--
mab
|