I have a set of URLs that end with a numeric ID of variable length (max 15 characters). The beginning of the numeric ID is always preceded by a forward slash. How do I create function to strip out the numeric ID only? Thanks.
I have a set of URLs that end with a numeric ID of variable length (max 15 characters). The beginning of the numeric ID is always preceded by a forward slash. How do I create function to strip out the numeric ID only? Thanks.
Without an example, you could try:
=MID(A1,FIND("/",A1)+1,LEN(A1))
Assuming the first cell with data you are trying to strip out is A1.
- Moo
try
=RIGHT(A1,LEN(A1)-FIND("/",A1))
Life's a spreadsheet, Excel!
Say thanks, Click *
I realized I forgot to include a key fact. The URLs will have more than one forward slash e.g., https://www.facebook.com/pages/The-D...37213556295908
Try
=TRIM(RIGHT(SUBSTITUTE(A1,"/",REPT(" ",255)),255))
when you say remove ,do wish to capture the number or the string before the number? or split and get both
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks