I have a spreadsheet pasted from elsewhere. I cannot remove 'blank' rows by
any normal formula, and despite looking empty I suspect that cells A1, C1,
.... must have some invisable or non-printable code in them. Hhow do I find
out what this is?
Thanks

did you try sorting so that "blank" rows come one side and delete these
rows.

If you want to find the non printable codes in the cells use pearsons
"cellview" add in
and use "trimall" sub from the following url
Location: http://www.mvps.org/dmcritchie/excel/join.htm
Home page: http://www.mvps.org/dmcritchie/excel/excel.htm
================

Kanga 85 wrote in message
...
I have a spreadsheet pasted from elsewhere. I cannot remove 'blank' rows
by
any normal formula, and despite looking empty I suspect that cells A1, C1,
... must have some invisable or non-printable code in them. Hhow do I
find
out what this is?
Thanks

Determine the length with =LEN(A1).

Determine the 1st character with =CODE(LEFT(A1,1))

If the 2nd formula returns 160, in the Search and Replace dialog, in the Find
What box, hold down the ALT key and on the NUMERIC KEYPAD type 0160. Leave the
Replace With box empty.

If it's come other number, again type ALT+the number in the Find What box.


On Tue, 22 Feb 2005 19:59:02 -0800, "Kanga 85"
wrote:

I have a spreadsheet pasted from elsewhere. I cannot remove 'blank' rows by
any normal formula, and despite looking empty I suspect that cells A1, C1,
... must have some invisable or non-printable code in them. Hhow do I find
out what this is?
Thanks

Thanks Myrna.
I don't want the data sorted Ventkat.

"Myrna Larson" wrote:

Determine the length with =LEN(A1).

Determine the 1st character with =CODE(LEFT(A1,1))

If the 2nd formula returns 160, in the Search and Replace dialog, in the Find
What box, hold down the ALT key and on the NUMERIC KEYPAD type 0160. Leave the
Replace With box empty.

If it's come other number, again type ALT+the number in the Find What box.


On Tue, 22 Feb 2005 19:59:02 -0800, "Kanga 85"
wrote:

I have a spreadsheet pasted from elsewhere. I cannot remove 'blank' rows by
any normal formula, and despite looking empty I suspect that cells A1, C1,
... must have some invisable or non-printable code in them. Hhow do I find
out what this is?
Thanks

WRT the sorting option that was suggested:

Use a spare column immediately adjacent to your data and fill it with serial
numbers (Edit/Fill/Series -- get more info from Help if you need it). Then you
can sort on the problem column to get the bad rows together, delete them, then
sort on the column with the serial numbers to get the remaining rows back into
their original order. Once you've finished, you can delete the column with the
serial numbers.


On Wed, 23 Feb 2005 00:39:01 -0800, "Kanga 85"
wrote:

Thanks Myrna.
I don't want the data sorted Ventkat.

"Myrna Larson" wrote:

Determine the length with =LEN(A1).

Determine the 1st character with =CODE(LEFT(A1,1))

If the 2nd formula returns 160, in the Search and Replace dialog, in the
Find
What box, hold down the ALT key and on the NUMERIC KEYPAD type 0160. Leave
the
Replace With box empty.

If it's come other number, again type ALT+the number in the Find What box.


On Tue, 22 Feb 2005 19:59:02 -0800, "Kanga 85"
wrote:

I have a spreadsheet pasted from elsewhere. I cannot remove 'blank' rows
by
any normal formula, and despite looking empty I suspect that cells A1, C1,
... must have some invisable or non-printable code in them. Hhow do I
find
out what this is?
Thanks