software

I have a column in spreadsheet excel, I have 30,000 items and I want to
drop the last line which is quot;Shipping charges wil apply to orders under
$100.00quot; this line is in every cell as the last line of the description
column. Is there a formula that will work?Hi Pete,
A formula can return a value, it cannot delete or hide a row,
for that you would need a macro (or conceivably a filter).

I suspect that you are trying to remove this text, or the
entire row from all sheets in a workbook, but that is not clear.
Can you more clearly identify what you want to do, and we'll
be in a better position to help you to write a macro.

Before you write a macro, you generally have to have a clear ideal of
how to do something manually.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: www.mvps.org/dmcritchie/excel/excel.htm
Search Page: www.mvps.org/dmcritchie/excel/search.htm

gt; wrote in message oups.com...
gt; I have a column in spreadsheet excel, I have 30,000 items and I want to
gt; drop the last line which is quot;Shipping charges wil apply to orders under
gt; $100.00quot; this line is in every cell as the last line of the description
gt; column. Is there a formula that will work?
gt;
If I understand you correctly, you want to get rid of the column which
contains this text 30,000 times - if so, just highlight the column by
clicking on the column identifier letter(s) and Edit | Delete.

Is this what you mean?

Petefind and replace? replace All quot;Shipping charges wil apply to orders under
gt; $100.00quot; with nothing
--
paul

remove nospam for email addy!
quot; wrote:

gt; I have a column in spreadsheet excel, I have 30,000 items and I want to
gt; drop the last line which is quot;Shipping charges wil apply to orders under
gt; $100.00quot; this line is in every cell as the last line of the description
gt; column. Is there a formula that will work?
gt;
gt;