Posted to microsoft.public.excel.programming

Abdul[_2_] Abdul[_2_] is offline

external usenet poster

Posts: 137

delete row if text not in specific format

Hi,

I have data in my column B

i want to delete all rows which are not in the specific format
00.000000.0000000.00.000.0000.0000

(zeros with any number)

thanks

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
Delete rows with specific text	David	New Users to Excel	5	April 3rd 23 07:29 PM
Delete Rows Without Specific Text	waggett	Excel Worksheet Functions	6	October 6th 09 11:34 AM
Change Date Format to Specific Text Format When Copying	[email protected]	Excel Discussion (Misc queries)	4	December 23rd 08 03:43 PM
Delete Rows With Specific Text	Sean	Excel Programming	1	August 19th 06 03:47 PM
Delete rows with specific text	MAYDAY[_3_]	Excel Programming	8	June 7th 05 08:38 PM

All times are GMT +1. The time now is 08:37 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us