I have a string of data in a cell that is always three numbers, followed by a space, and then a varying number of words, with spaces between them. I want to separate the numbers from the varying string of words, keeping the word string together. For example:
I have:
123 Department Black Cat
and I want:
"123" in one cell, and "Department Black Cat" in another
Another example is, I have:
456 Charming
and I want
"456" in one cell, and "Charming" in another.
do you have ideas / suggestions for this? I'd usually replace space with a character and then text--> column, but this time I need to keep the second piece together, and this seems like a long work-around.
Bookmarks