I have looked through the forum at similar topics, but I was not able to find one that answered my question sufficiently. I have an Excel sheet which contains data in one column (some numbers and text all in single cells). I would like to take this single column and split it into two separate columns by separating the numbers and text.
Here is an example of what the before Excel would look like:
And here is what I want it to look like after:
I’d really appreciate your help if you could provide me with an approach or some example of this being completed.