Extracting Text within 2 Symbols in Excel

Hello EE,

I have the following dummy URL: http://www.amazon.com/dp/BPPK0T2MQI/  and i want extract BPPK0T2MQI.  Can someone please help me with an excel formula to extract.

Who is Participating?
Roy CoxConnect With a Mentor Group Finance ManagerCommented:
Assuming the text is in A1 try

davorinConnect With a Mentor Commented:
You can try with =right(cell address, number of characters) if the number of extracted characters is always the same.

In your case if url is in A1 cell:
put next formula in B1 cell "=right(A1,11)" . You will get "BPPK0T2MQI/"
and then put next formula in C1 cell "=left(B1,10)" - you will get "BPPK0T2MQI"


You could also use text to columns function and select / as column delimiter. You will get wanted strings in 5th column.
fb1990Author Commented:
Thanks to both of you.  I can use this for now.  It assumes the value will always be 10 digit. it may be more in the future.
Roy CoxGroup Finance ManagerCommented:
Pleased to help.
Roy CoxGroup Finance ManagerCommented:
There might be a simpler formula but this allows for varying lengths  of text

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.