Split Text between Upper and Lower Case in Excel

Separating text that should have been in two columns instead of one is easy to do if there is some kind of delimiter (i.e., comma or colon). But if it was two words like first name and last name that was combined; and the only way to make out the beginning vs. end is the case (Upper case vs. Lower case; like BobSmith). There's actually a really easy way to do this and then there's the super nerdy formula combination way. I'll show both ways but show the formula way first. 😉

0:00 Intro
0:53 Formula/Function Combination
6:02 Easy Flash Fill

🔔 SUBSCRIBE to my channel ➜ https://goo.gl/wN3c3p

🏫 Excel Training ➜ https://www.exceltraining101.com/p/tr...

📚 Excel Books & Tech Gear ➜ https://www.amazon.com/shop/dough

⚙️ Tools: Screencasting ➜ https://techsmith.z6rjha.net/5Qe53

⚙️ Tools: Microsoft Office ➜ https://microsoft.msafflnk.net/rKL0G

⚙️ Tools: TubeBuddy ➜ https://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 https://www.buymeacoffee.com/dough

#excel
#msexcel
#doughexcel