Separate Numbers from text in Excel using Flash Fill – Ctrl E
Amazingly useful.
Also available in Power Query as Add Column By Examples.

Read detailed articles on Dr Nitin’s blog
Introduction: https://efficiency365.com/2013/11/30/excel-data-cleanup-with-flashfill/
Deep Dive: https://efficiency365.com/2014/04/16/data-clean-up-using-flash-fill-in-depth/

Buy Dr Nitin’s latest book
—————————————–
Efficiency Best Practices for Microsoft 365
130 best practices everyone must know
Work Smarter, Grow Faster

https://s.efficiency365.com/bk

Dr Nitin Paranjape is the pioneer in maximizing work efficiency in a modern work scenario.
Dr Nitin’s Office Masterclass
———————————————-
https://hi.switchy.io/mms

Udemy Courses by Dr Nitin Paranjape
————————————————————–
Pivot Table Advanced – https://hi.switchy.io/22B1
Excel to Power BI – https://swiy.io/pivotsh

Learn more from 1000+ blog articles by Dr Nitin Paranjape
Efficiency 365 blog: https://efficiency365.com/blog

LinkedIn : https://www.linkedin.com/in/nitinparanjape/
Twitter : https://twitter.com/drnitinp

Production
——————–
Music and Effects: https://www.epidemicsound.com
Created using Camtasia: https://www.techsmith.com/video-editor
AI based captions: https://videoindexer.ai (Microsoft service)