removing text from excel cells

[croxsons]

my wife has a problem. They have a master sheet in excel, with license numbers starting with FL.

Is there a formula to get Excel to strip out the text, just leaving numbers?

I know that there is RIGHT formula, but this is too specific to the number of characters, some licenses will have less numbers for example.

[croxsons]

SeanyD said:

Assuming cell A1 contains 'FL123456' or whatever length the number happens to be

In cell B1 put =MID(A1,3,1000)

worked brillantly. cheers.

I know the substitute would have worked well as well though. Should have thought of that.

I have a very thankful wife, so cheers for that.

[croxsons]

SeanyD said:

No worries Tim, make sure she rewards you well.

she is how do you say, "with child," due in under six weeks incidently. got me in this position as it is!