| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Linking two spreadsheet, pulling data from one cell to another, data is being truncated | Excel Worksheet Functions | |||
| How 2 Link DATA instead of CELL REFERENCE - Pulling My Hair Out! | New Users to Excel | |||
| Formula for Pulling partial data from one cell into another | Excel Worksheet Functions | |||
| moving data to a cell, not pulling data to the cell | Excel Worksheet Functions | |||
| pulling certain data out of a cell | Excel Worksheet Functions | |||
Linear Mode
