Link to home
Start Free TrialLog in
Avatar of wagamama123
wagamama123

asked on

trying to extract a text string from a given area in a cell

I am trying to extract a text string in a cell within a givien set of characters. I have enclosed an example. text-extract-spread.xlsx
Avatar of Ingeborg Hawighorst (Microsoft MVP / EE MVE)
Ingeborg Hawighorst (Microsoft MVP / EE MVE)
Flag of New Zealand image
try this

=LEFT(MID(A5,FIND("(",A5,FIND("(",A5)+1)+1,99),FIND("-",MID(A5,FIND("(",A5,FIND("(",A5)+1)+1,99),2)-1)+0
ASKER CERTIFIED SOLUTION
Avatar of kgerb
kgerb
Flag of United States of America image
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of reitzen
reitzen
Flag of United States of America image
Here is one way of approaching this
=MID(A1,FIND("(",A1,FIND("(",A1,1)+1)+1,FIND("-",A1,FIND("(",A1,FIND("(",A1,1)+1)+2)-FIND("(",A1,FIND("(",A1,1)+1)-1)

Open in new window

Avatar of barry houdini
barry houdini
Flag of United Kingdom of Great Britain and Northern Ireland image
If the last number is always 3 digits as per your example, 110, 114 etc. then this should work

=LOOKUP(10^5,RIGHT(LEFT(A1,LEN(A1)-6),{1,2,3,4,5})+0)

regards, barry
Avatar of wagamama123
wagamama123

ASKER

thank you!
Avatar of kgerb
kgerb
Flag of United States of America image
Was there something in your data set that caused mine to work where teylyn's, reitzen's, and Barry's didn't?