Excel Pro Tip: How to Easily Extract Numbers from Cells
ฝัง
- เผยแพร่เมื่อ 26 ส.ค. 2024
- Subscribe to my channel and unlock exclusive benefits!
@ASVExcel
Streamline your data in Excel with this powerful technique to extract numbers from cells containing both text and numbers. This tutorial shows you how to quickly identify and isolate numerical data with Excel's Flash Fill feature.
🎓 What You'll Learn:
• Utilizing Flash Fill to seamlessly extract numbers from mixed content cells.
📌 Key Takeaway:
• Mastering Flash Fill enhances your data analysis efficiency, turning complex tasks into simple clicks.
If you find this tip helpful, please give it a thumbs up and subscribe for more efficient Excel techniques.
Duuuuuuuuude - I was halfway through a 6 minute video with some guy creating complex formula in 6 extra rows then you come along with CTRL E. Boom !
My general approach is to make things as simple as possible, not vice versa...
Ctrl+E won't work in old excel
holy cow, this is the fastest of all the videos I've seen trying to understand their formulas and so on
This is amazing! And works for much more than numbers! Thank you!
You just saved me time counting the number of characters using the Mid function and for that I thank you sir! Good day to you!😄
You're welcome!
I have been on this spreadsheet for nearly half an hour, looked st half a dozen videos and it's done in seconds. 😂Brilliant. You changed my life. I must tell the others!
Glad it helped :)
UNBELIEVABLY helpful tip!! I've been looking for a way to do this forever and you've solved the puzzle!!!
Glad I could help!
Saved me so much time with this, thanks!
You are welcome :)!
saved me 30 min thank you sir
You're welcome!
thanks man people were giving formula for this
You are welcome :)!
amazing this really help guys who want to learn excel
THANK YOU!!!
You're welcome.
Thank You so much for this! :)
You are welcome :)!
OMG You are amazing at instructions!!! This works perfectly!!! You literally saved my life!!!
You're welcome.
It's amazing ...
Thanks it's been a while now that I was looking for this tips to help perform faster at my work. Thank you much
You're welcome.
I didn’t except this will work😂
I am surprised, more than excellent
Thank you.
Thanks a lot CTRL E 🔥 must be one of the most powerful shortcuts in excel
You're welcome. I think it is one of the best shortcuts in Excel.
You are a great saver. Thank you.
You're welcome.
Thanks buddy, it really helps a lot, a hell of a shortcut.
You're welcome.
this is genius level
Thank you.
Thank you😊
You're welcome!
thank for a great tip. save the time.
You're welcome.
This was a great tip 🙂Thank you!
You're welcome.
Simple formula thanks for this TIP
You're welcome.
WOW. TY!
You're welcome.
That was brilliant. Thank you.
You're welcome.
You are the GOAT !!!!
Thank you!
Oh my gosh!!!! Thank you so much ❤❤❤❤❤
You're welcome.
wow...nice..so lucky i found u...tq
Thank youuuuuu so much
Great tip, thanks!
You're welcome.
Dude your the master
Thank you.
Thanks ❤
Thankyou❤
thanks alot
you are Amaaaaziing Thaaank you sooo much
You're welcome.
Love you man.
You're welcome.
You are excellent bro ..
Thank you.
Can we separate if written like this
1 box=12pcs
1 box=24pcs
Only need 12,24
Like this?
Please help 🙏
my brain just exploded
Genuis!
Thank you.
🎉😊❤
Not all heroes wear a cape
Thank you.
Guys it is not working for me, How is it done !!
Please read this: support.microsoft.com/en-us/office/using-flash-fill-in-excel-3f9bcf1e-db93-4890-94a0-1578341f73f7#:~:text=You%20can%20go%20to%20Data,the%20Automatically%20Flash%20Fill%20box.
Doesn't work for me....trying to convert an income statement with GL numbers and the GL Name in the same cell, to pull out the numbers. Tried this, didn't work.
I just found the solution, you can do more examples in different rows then it will refine the trend from CTL E.
Truee, try it to other rows, it will work.
😮😮😮😮