Need to remove lines with no value in column M in Excel.

CougarSE · 09-04-07, 01:05 PM

I have a csv file with over 65k lines in it. I need to remove all lines that do not have a value in column M. I'm at a loss, I'm Excel stupid.

hafa · 09-04-07, 04:13 PM

select all>data>sort by column M, select top x rows where M is blank and delete. Either that or import it into MSSQL EM or studio 2005 and run: delete from tablex where colM ISNULL.

Omsion · 09-05-07, 04:43 AM

Quote:

Originally Posted by hafa

select all>data>sort by column M, select top x rows where M is blank and delete.

I'd go with that. I was going to suggest a quick macro with an "if", but that one's simpler.

09-04-07, 01:05 PM	Thread Starter #1
CougarSE Member Join Date: Nov 2006	Need to remove lines with no value in column M in Excel. I have a csv file with over 65k lines in it. I need to remove all lines that do not have a value in column M. I'm at a loss, I'm Excel stupid.
	QUOTE Thanks

09-04-07, 04:13 PM	#2
hafa Premium Member #24 Join Date: Apr 2003 Location: A tiny dot in the middle of the Pacific	select all>data>sort by column M, select top x rows where M is blank and delete. Either that or import it into MSSQL EM or studio 2005 and run: delete from tablex where colM ISNULL. __________________ . HTPC: Core i3 540/8GB/300GB Raptor/GTS450-1GB/W7P-64 ~\|~ File Server: (Green) AMD 4850E/4GB/6TB RAID/Windows Server 2008 ~\|~ Notebook/Workstation: M780 Toshiba Convertible Tablet/i7 M620/8GB/128GB Crucial M4 SSD /7200RPM 750GB/W8 Pro Putting the YO back in YOU(')R(E)... \| Who is this "u" person, anyway?
	QUOTE Thanks

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search

Need to remove lines with no value in column M in Excel.

Internet Services

Website Development

Tech Hardware