Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Delete rows with certain text
Hi!
I want to delete rows in certain with a certain text in the b column. 2704000 528050 0 0 121637 #N/A 0 0 151637 #N/A 0 0 126397 #N/A 0 0 121637 761900 0 0 521537 #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A Ie in this example i want to remove all columns that have #N/A in them in the B column! How do i do that? Ive tryed mixing some macros but im not so good at them... |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Delete rows with certain text
Try this:
Select the Col_B data range. From the Excel main menu: <edit<find Find what: #N/A Click the [find all] button While the list of all matching cells is displayed: Hold down the [ctrl] key and press A (That will select all of the #N/A cells in Col_B) Next: From the Excel main menu: <edit<delete<entire row Does that help? *********** Regards, Ron XL2002, WinXP "Pete" wrote: Hi! I want to delete rows in certain with a certain text in the b column. 2704000 528050 0 0 121637 #N/A 0 0 151637 #N/A 0 0 126397 #N/A 0 0 121637 761900 0 0 521537 #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A Ie in this example i want to remove all columns that have #N/A in them in the B column! How do i do that? Ive tryed mixing some macros but im not so good at them... |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Delete rows with certain text
"Pete" wrote in message
... Hi! I want to delete rows in certain with a certain text in the b column. 2704000 528050 0 0 121637 #N/A 0 0 151637 #N/A 0 0 126397 #N/A 0 0 121637 761900 0 0 521537 #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A Ie in this example i want to remove all columns that have #N/A in them in the B column! How do i do that? Ive tryed mixing some macros but im not so good at them... Autofilter, & delete the rows that show. -- David Biddulph |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
limiting rows of text in a textbox object? | Excel Worksheet Functions | |||
Macro to delete rows with same data | Excel Worksheet Functions | |||
Want to delete rows | Excel Discussion (Misc queries) | |||
Delete all rows where Column A contains Text | Excel Worksheet Functions | |||
How to create a Pivot table from text file with more than 65000 rows? | Excel Discussion (Misc queries) |