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. |
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. |
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))) |
All times are GMT +1. The time now is 06:46 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com