need to edit excel spreadshhet

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Pete.Cornejo@gmail.com - 22 May 2006 21:45 GMT

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

Reply to this Message

David McRitchie - 22 May 2006 22:05 GMT

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: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

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

Reply to this Message

Pete_UK - 23 May 2006 01:06 GMT

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?

Pete

Reply to this Message

paul - 24 May 2006 11:58 GMT

find and replace? replace All "Shipping charges wil apply to orders under

> $100.00" with nothing

Signature

paul
paul.shepherd@nospamparadise.net.nz
remove nospam for email addy!

Reply to this Message