• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 150
  • Last Modified:

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.

  • 3
2 Solutions
Roy CoxGroup Finance ManagerCommented:
Assuming the text is in A1 try

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.

Join & Write a Comment

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now