Excel 2007 Text to Columns Without Changing Numbers
I am trying to separate numbers and text in a column but when I run the Text to Column function its removing the zeros in front of the numbers and I want them to remain intact. For example, a cell that shows: 000111 Joe Smith will end up having 111 in one column and Joe Smith in the other once the data is split.
Any recommendations on how to prevent this from happening? Open to macros if that's the best solution.