Thread: How to find & delete a particular pattern of text from values of a
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
  
Posts: 8,651
Default How to find & delete a particular pattern of text from values of a
=IF(LEFT(A2,2)="FL",--RIGHT(A2,LEN(A2)-2),A2)
--
David Biddulph

"Mansa" wrote in message
...
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


Reply With QuoteReply With Quote