Excel - Remove Numbers from a Cell Containing Text

Learn how to remove numbers from a cell containing text in Microsoft Excel.
Sign up to get updates, practice files and code snippets eepurl.com/hwyGg1
#excel #remove #numbers

[@sherriunger4916]

UNBELIEVABLE! This was too easy after hours of manually typing the data separate from numbers. Thank you!

[@getupstairstobed]

Can't believe this fixed the problem so quickly, my version of excel said "er, sorry, no can do", got disappointed looked and thought "where's all the numbers gone, woohoo" lol genius solution, thanks very much

[@tinashemujokoro1342]

You're a life saver bro! Been looking for this for past 30mins and your answer was so simple. Many thanks!

[@jakehundley]

This is amazing. Looked on another blog post and they were suggesting a formula akin to producing your own version of Jarvis. My problem was that the column had 1,000 rows of data each prefaced with 1., 2., 3.,...11., 12.,...105., 106., etc. This removed the entire numerical sequence in 5 seconds.

[@ferdoaskhan7180]

Wow so simple. Explained so well. Great teacher !!😍

[@ExcelGoogleSheets]

👍

[@mycophil]

Great video, helpful and all! Wish you would've pasted the formula in the description though.

[@Itegie]

Hat's off bro, you saved me alot of efforts and time

[@kaythesis1889]

Thank you so much, you gave the best explanation on this topic out here!

[@jackpendergrass2160]

I want to use the leftover letters and copy and paste them into another file to cross check with another set of data. Is won't let me copy the letters, it only pastes the formula. Any suggestions?

[@zamazitumane8159]

OMG this was too easy. thank you

[@LucaMss]

Awesome! You basically solved me hours of work! Thanks so much!!

[@GeorgeReinoso]

Thanks! spent bunch of time deleting numbers

[@candid0111]

This was so easy. First one fixed all my issues.

[@FSANCHEZog]

Great video, always with the best content related to spreadsheets ❤

[@ExcelGoogleSheets]

:)

[@filipdaszkiewicz]

In Excel I can use "let" variable to store temporarily set of data in formula so is really cool and is anything like that in spreadsheet ?

[@ExcelGoogleSheets]

No, not available in google sheets.

[@mohdhassan2677]

Can this formula be modified so that it gives numbers in group? I mean for example to extract numbers from "abc123def456ghi78" as "123-456-78"?

[@ExcelGoogleSheets]

You can format your number. =TEXT(formulainthevideo*1,"###-###-##")

[@duanquan8854]

Hi there, thank you so much for such informative video. I have a request, please help me if you can. My data looks something like this - "3.50 Good Earth 3.75 Hail Sezer 4.33 Cottam Lane". Now using the Flash function I can separate the text and digits, however, what I want is each name set should go in each column. I tried doing - Good Earth in one column and used FlashFill it worked for few but in some cases it brought the digits too. The Flash fill is failing in those rows where there is no second word in the column; for e.g. if the row contained "3.50 Good Earth 3.75 Hail Sezer 4.33 Cottam Lane" and if I write Good Earth in next column it works fine for "1.67 Courageous Knight 6.00 Ezaj 8.00 Quinault" but if there was "3.25 Ebury 5.00 Antagonize 5.00 Truth In Jest", the answer of flash fill was "Ebury 5.00 Antagonize" I think if somehow I can tell Excel that these two are a "set", it will work, isn't it? Please guide

[@ExcelGoogleSheets]

No, you will need to use VBA or a very complicated formula.

[@ExcelGoogleSheets]

Maybe try Power Query Split functionality. Newer version have options split by digit.

[@aviadbenhamo5812]

How can I get the same result with regex extract?

[@ExcelGoogleSheets]

Use REGEXREPLACE. =REGEXREPLACE(A1,"[0-9]","")

[@Diamond0dust]

Many many thanks, saved hours of labor.

[@_adityatripathi]

Great. It worked. Thanks a lot❤

[@bethcunningham176]

Thank you so much for this vid. Very helpful

[@ExcelGoogleSheets]

👍

[@StopForeclosureMortgage]

awesome and so simple

[@rasheedrck]

How to remove serial numbers mixed with text ?

[@சூப்பர்தமிழா-ய6ற]

Very useful sir ❤❤❤

[@nhule8442]

Wow 👏thank you 💕💕

[@dennischua193]

Thank you for this. Amazing video. :)

[@mentalhealthlove8717]

Masterful!

[@ShubhamTiwari-e5x]

Thank you

[@சூப்பர்தமிழா-ய6ற]

Is it possible in regex?

[@ExcelGoogleSheets]

Not in Excel. In Google Sheets you can use REGEXREPLACE. =REGEXREPLACE(A1,"[0-9]","")

[@Jonathan23-P2]

Thanks guy for ur help

[@ExcelGoogleSheets]

👍

[@aboali9299]

THANK YOU VERY MUCH

[@Fayery_Random_YT]

thank you so much!!

[@rdchen492]

You could use the approach you talked about in your November 16, 2021, "Excel REDUCE Function - LAMBDA Array Formulas," to solve this problem. =LET( str,A1, arr, {0,1,2,3,4,5,6,7,8,9}, REDUCE(str,arr,LAMBDA(a,r,SUBSTITUTE(a,r,""))) )

[@ExcelGoogleSheets]

:) Keep in mind that REDUCE is currently only available to Office Insiders.

[@rdchen492]

@@ExcelGoogleSheets It's available to me even though I'm not an Office Insider. I've Office 365. There is one topic I haven't seen any talk about, specifically, LAMBDA functions can take a function as parameter, like a callback function. Perhaps you can do a video on that topic. For example, here is such a function: CallBack = LAMBDA(f, x, f(x)) If "Factorial(n)" is a factorial function of n, then CallBack(Factorial, 10) would yied 3,628,800. If "SumIntegers(n)" is function summing 1 to n, then CallBack(SumInteger, 10) would yield 55. But I can't think of a good use case for this very nice feature in Excel. Hope you can come up with some idea. For a Google Spreadsheets apologist, you make best tutorials on Excel Lambda and its helper functions.

[@danielhuertas2239]

Why not just include the function in the description smh. now let me go and type that whole thing

[@munnakarthiko1]

🫡 Guru🙏🏾🪷

[@ramkumara1992]

Thank you