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.

[SeanyD]

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

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

[tigger1]

There's a function called "substitute" that will let you do this.

=substitute(A2, "FL", "&quot

This will replace in A2 "FL" with ""

[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.

[SeanyD]

No worries Tim, make sure she rewards you well.

[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!

[dazren]

A few O/T posts deleted. Looks like some riff raff have escaped the P&P. The tracker dogs have been let loose.

OP's question already answered so:

[THREAD CLOSED]