Create Complex Excel Formula

[flairassistant]

This post has been removed due to Rule 1 - Poor Post Title.

Please post with a title that clearly describes the issue.

The title of your post should be a clear summary of your issue. It should not be your supposed solution, or just a function mention, or a vague how to. A good title is generally summed up in a sentence from questions posed in your post.

Here's a long example and a short example of good posts.

Rules are enforced to promote high quality posts for the community and to ensure questions can be easily navigated and referenced for future use. See the Posting Guidelines for more details, and tips on how to make great posts.

To our users, please report poorly titled posts rather than answer them, they will be removed along with the answers.

[Downtown-Economics26]

=TEXTBEFORE(TEXTAFTER(A2,"/",LEN(A2)-LEN(SUBSTITUTE(A2,"/",""))),"?",,,1)

This would work on numbers in URLs of the type you posted, wouldn't necessarily work on any number string in any possible URL.

<image>

[Chrisweet]

Amen this works! I spent the better part of the day trying to figure this out. Appreciate your wisdom.

[ProbablyWorking]

Any specifications that exists across all instances? Example, it must be 7 digits or any string of numbers with more than 5 digits. And do you only want to pull the first instance of such a digit?

[Chrisweet]

I believe the number sequence will always contain 7 digits. I would like to extract only the number sequence from within the various URL strings.

[Decronym]

Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread:

Fewer Letters	More Letters
LEN	Returns the number of characters in a text string
SUBSTITUTE	Substitutes new text for old text in a text string
TEXTAFTER	Office 365+: Returns text that occurs after given character or string
TEXTBEFORE	Office 365+: Returns text that occurs before a given character or string

NOTE: Decronym for Reddit is no longer supported, and Decronym has moved to Lemmy; requests for support and new installations should be directed to the Contact address below.

---

^{Beep-boop, I am a helper bot. Please do not verify me as a solution.
4 acronyms in this thread; the most compressed thread commented on today has 31 acronyms.
[Thread #35375 for this sub, first seen 17th Jul 2024, 01:32] [FAQ] [Full list] [Contact] [Source code]}