Excel 2007 : Dropping off a variable number of characters

[Corydon]

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!

[NBVC]

Try

=MID(A1,Find(" ",A1)+1,100)

where A1 contains the original number...

[sweep]

Hi,

Give this a try:

=RIGHT(A1,LEN(A1)-FIND(" ",A1))