Hi,

I am in need of help with something I have never encountered before in
Excel. At work, I have an extremely long (over 20,000+) list in excel.
The problem is that there is sporadic and unpredicatable places in the

cells that have a BLANK BOX character much like : □ . Except,
HOWEVER,
it is slightly TALLER, thinner box. I can't copy and paste it here for
you to see, becuase it won't transfer! HERE- '
' The mysteries BOX is between the 'quotes'. Its just half line of
empty
space and it cannot be seen.

I need to be able to COPY and paste that empty box (looks like □,
expect taller and thinner and unable to replicate in Word, Excel, or
Notepad) Basically there are thousands of these annoying little things
in the thousands of cells that I have in this one excel sheet. It would
be MUCH more efficent use of time if I could SEARCH for the Empy Box and
replace it with Blank characters to get rid of /erase the annoying
boxes. But I am unable to do [search/replace] that in Excel (or word or
notepad for that matter) becuase I CANNOT copy and paste the character
into any fields, or anywhere! I have already searched on the internet
about this matter but to no avail, I have went through all of excels
related help docutments but still no use. There must be a clever way to
do this! I have tried using the MS CHaracter Map but the boxes are still
not exactly like the one I have in excel, so I cannot use it. I have
tried everyone of the alt key characters from 1 to 256 and none of them
match the one I have in excel,

can anyone please help!

Thanks,
Bo


--
bxc2739
------------------------------------------------------------------------
bxc2739's Profile: http://www.excelforum.com/member.php...o&userid=32538
View this thread: http://www.excelforum.com/showthread...hreadid=523214