Hello Everyone,

I have two cells in different columns that look like this 10 23 4 56 1 1 1 1 and 3 27 3 56 1 1 1 1. Each one has eight numbers seperated by a space. What I need is to drop off the first number (wether it is one or two digits) up to the first space. As per the example above I would need an output of 23 4 56 1 1 1 1 and 27 3 56 1 1 1 1. It's hard to explain what I'm doing but that's the end game I need. I know how to drop off a fixed number of characters but I really need the first characters dropped off up to that first space.

Thanks!