"it not working" is this week's leader in the "unhelpful description of a
problem" competition.

What result did my formula give? What result did you expect?
--
David Biddulph

"Mansa" wrote in message
...
Thanks David and Mike for your analysis, but sorry it not working.

I'll again simply my doubt.I have a column which has following values :

50099532
50099532
50099532
FL0050069061
FL0050069061
FL0050069061
FL0050069061
FL0050069061

I need to remove any occurance of "FL00", "FL000", "FL:000", "FL 000", "FL
00", "000" from values in above column.

E.g. "FL00050200986" becomes ""50200986" after removal.

Hope this will make my query more clear.

Please extend your help solve this one.

Many thanks again!

Regds,
Mansa

"Mike H" wrote:

Maybe


This assumes the characters after the FL are zeroes

=MID(A1,MIN(FIND({1,2,3,4,5,6,7,8,9},A1&"123456789 ")),LEN(A1))

Mike

"Mansa" wrote:

I have a columns having values like 50200986, FL0050200987,
FL000050200234 etc.
I want to find and remove FL00, FL000 etc and keep only the values
which are
trimmed of FL, FL00 or FL000 etc.

Please help .

Manish