| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Obtain Middle vlaue of text with unknow length
Hi,
I have many cell with values like 01/ab123/09 01/123A/09 1/1A/9 I want to extract the middle value of each cell how could I do This. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Obtain Middle vlaue of text with unknow length
=LEFT(RIGHT(A1,LEN(A1)-FIND("/",A1,1)),-1+FIND("/",RIGHT(A1,LEN(A1)-FIND("/",A1,1))))
-- Gary''s Student - gsnu200902 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Obtain Middle vlaue of text with unknow length
Try this:
=MID(A1,FIND("/",A1)+1,FIND("/",A1,FIND("/",A1)+1)-1-FIND("/",A1)) -- Biff Microsoft Excel MVP "Abdul Shakeel" wrote in message ... Hi, I have many cell with values like 01/ab123/09 01/123A/09 1/1A/9 I want to extract the middle value of each cell how could I do This. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Obtain Middle vlaue of text with unknow length
=TRIM(MID(SUBSTITUTE(A1,"/",REPT(" ",99)),99,99))
"Abdul Shakeel" wrote: Hi, I have many cell with values like 01/ab123/09 01/123A/09 1/1A/9 I want to extract the middle value of each cell how could I do This. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| hi, how to display my text vlaue in Axis (ex: J, F, M, A....) | Excel Discussion (Misc queries) | |||
| How can I obtain the average of the middle quartile of an array? | Excel Worksheet Functions | |||
| Variable length array that exludes (possible) blanks in the middle | Excel Discussion (Misc queries) | |||
| IF and OR functions to obtain text descriptions | Excel Worksheet Functions | |||
| Add totals at end of the report with unknow number of rows with VB | New Users to Excel | |||
![Abdul Shakeel[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
