B
bxc2739
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
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