Monday, March 6, 2023

Separate Text and Numbers in Excel

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 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 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.

No comments:

Post a Comment