Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Extracting certain text
I have a list of text in each cell where I have to extract the #% after the
"Y-" Here is an example, the string is Y-24.47% P-24.37%. I need to extract 24.47% Is there a formula for this? Any help is much appreciated. Thanks. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Extracting certain text
=MID(A1,FIND("-",A1)+1,FIND(" ",A1)-FIND("-",A1)-1)
-- David Biddulph "Confused" wrote in message ... I have a list of text in each cell where I have to extract the #% after the "Y-" Here is an example, the string is Y-24.47% P-24.37%. I need to extract 24.47% Is there a formula for this? Any help is much appreciated. Thanks. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Extracting certain text
Confused wrote:
I have a list of text in each cell where I have to extract the #% after the "Y-" Here is an example, the string is Y-24.47% P-24.37%. I need to extract 24.47% Is there a formula for this? Any help is much appreciated. Thanks. With your strings of text in A2 and down and your search terms ("Y-", "P-", etc.) in B1 and across as needed, put this in B2 and copy down and right: =MID($A2,FIND(B$1,$A2)+LEN(B$1),FIND(" ",$A2&" ",FIND(B$1,$A2))-(FIND(B$1,$A2)+LEN(B$1))) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Extracting Text | Excel Worksheet Functions | |||
Extracting Text only | Excel Worksheet Functions | |||
Extracting Text from the right | Excel Worksheet Functions | |||
extracting text only | Excel Worksheet Functions | |||
EXTRACTING TEXT | Excel Discussion (Misc queries) |