Thread: How to find & delete a particular pattern of text from values of a
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mansa Mansa is offline
external usenet poster
  
Posts: 5
Default How to find & delete a particular pattern of text from values of a
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