What is invisible in a cell?l

[Kanga 85]

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

 

[Myrna Larson]

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.

 

[Kanga 85]

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

 

[Myrna Larson]

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.