i have a problem in excel where i have to delete a field out of every odd numbered column.

whats the formula to do this w/out having to do this manually. manually I'd have to delete each entry for the next 3000 lines.

please help me . . .

9/7/2005 3:31:03 PM

http://www.asap-utilities.com/

[Edited on September 7, 2005 at 3:38 PM. Reason : d]

9/7/2005 3:38:00 PM

i think what i need is a macro off the content in the field to delete. for instance it's "011" which I need to delete out of all of the columns.

9/7/2005 3:55:22 PM

wait wait wait

if every cell you want to delete in that row says 011

why don't you just sort the table by rows

9/7/2005 3:56:59 PM

[pseudocode]
for rowI=1 to 4000
for columnJ = 1 to 80
cells (rowI, columnJ) = ""
columnJ = columnJ + 2
loop
loop
[/psuedocode]
this would delete every cell in odd columns
you could add an if statement to check for certain values

[Edited on September 7, 2005 at 5:39 PM. Reason : .]

9/7/2005 5:38:55 PM

If you install that plugin it will do all of what you want and there are tins of other options.

I love it.

I spend my day in excel and it doesnt bog down Excel at all with a bunch of loaded macros

9/7/2005 7:24:22 PM