View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
mab2819 mab2819 is offline
external usenet poster
 
Posts: 3
Default 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