When you’re cleaning up some data, maybe you get something where the number and text are combined and need to be separated or split into columns. It could be something as easy as when a fixed set of numbers come after text or a little more complicated where some set of variable numbers come first.
Or ...it could be something as hairy as when a bunch of numbers and text are joined together in multiple random lengths.
Do you have to write complex formulas or VBA to clean this up? No way...it can be done with a few keystrokes and maybe even just one hand.
I’ll show examples of how we could separate the number and text in native Excel and then with Power Query.
0:00 Intro
0:54 Split Number before Text
1:42 Split Text before Number
2:20 Using Power Query
4:20 Separate Digit and Non Digit in Different Places
🔔 SUBSCRIBE to my channel ➜ goo.gl/wN3c3p
🏫 Excel Training ➜ www.exceltraining101.com/p/tr...
📚 Excel Books & Tech Gear ➜ www.amazon.com/shop/dough
⚙️ Tools: Screencasting ➜ techsmith.z6rjha.net/5Qe53
⚙️ Tools: Microsoft Office ➜ microsoft.msafflnk.net/rKL0G
⚙️ Tools: TubeBuddy ➜ www.tubebuddy.com/et101
📝 This description may contain affiliate links and we'll receive a small commission if a purchased is made using the links (but at no additional cost to you). It'll support the channel and so more videos like this can be made. Thanks for your support!
🎁 If you find these videos useful and want to support my channel go to
www.buymeacoffee.com/dough
#excel
#msexcel
#doughexcel
~-~~-~~~-~~-~
Please watch: "Convert Table in a PDF File to Excel"
• Convert Table in a PDF...
~-~~-~~~-~~-~