I have cells that contain either a three digit, four digit or five digit number followed by a name. How can you split that cell (without using text to columns) so that in one new cell it contains the number and the next column it says the name. I am still a newbie to excel
thanks
thanks