ExcelBanter - Pulling data from a cell in between /

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Pulling data from a cell in between / (https://www.excelbanter.com/excel-worksheet-functions/192098-pulling-data-cell-between.html)

mab2819

Pulling data from a cell in between /

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

Bob Phillips[_3_]

Pulling data from a cell in between /

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

mab2819

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

All times are GMT +1. The time now is 04:49 AM.