Google Sheets - Extract Numbers from Text

If you have a string of characters from which you would like to extract numbers, there are several different ways to accomplish this. This video will walk you through extracting the first numbers, all of the numbers, and extracting the number in pieces. We will do it all without a plugin and then accomplish the same things using a plugin called Power Tools.

The formulas are on the blog here:

If you are interested in Power Tools, please use this link for discounted pricing:

🕒 Timestamps:
0:00 SPLIT into different columns
4:32 REGEXREPLACE (All of the numbers)
6:08 REGEXEXTRACT (Just the first set of numbers)
7:38 Automate it with Power Tools
10:52 Next videos - Interactive Task List

Learn more from Prolific Oaktree:

#googlesheets #spreadsheet #REGEX

[subratamajumder]

Sir, I am phasing problem to extract. (Example:
BS
34, 084
+349.78%
I want to get 34084.
Another one:
BS
7, 422
0.00%
I want to get 7422
What should I do. Please guide me.

[logangrwinski]

For the Regex replace, It has not been bringing back 0's. Any suggestions on how to get those to populate?

[jomerbongalos]

Hi, can you help me on this? I'm trying to extract numbers from the string and it's fine, but aside from numbers I need to extract the letter before the number IF that letter starts at A, B, C and in Uppercase. usually the numbers are preceded by "p" because they're page numbers but some strings have letters after the "p", like instead of p12 it's pA12. Thanks!!

[johnguilfoyle]

In all of these examples, you couldn't show a Street Address where the House Number needs to be extracted?

[danni]

Thankyou sooo much for this honestly! :D

[junctionholidays]

WHAT DISCOUNT YOU CAN GIVE ON POWERTOOLS

[diaertrampe]

This is exactly what i needed. Thank you. :)