Posted to microsoft.public.excel.misc

Mansa

external usenet poster

Posts: 5

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 Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
query with formula/macro to find text in worksheet and delete it	James	Excel Worksheet Functions	3	February 8th 08 06:59 AM
find text and delete rows.	John	Excel Discussion (Misc queries)	5	December 12th 07 04:25 AM
Identifying A Pattern Of Values Meeting Specific Criteria	CSHAKES	Excel Discussion (Misc queries)	3	June 17th 07 06:55 AM
find cell that contains text and delete entre row	Cristi R	Excel Discussion (Misc queries)	3	August 2nd 06 04:32 PM
Function to find duplicate values, then delete	Cam	Excel Worksheet Functions	1	January 27th 06 01:38 AM

All times are GMT +1. The time now is 11:55 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us