Monday, October 3, 2022

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 Bob Smith). 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.

No comments:

Post a Comment