G
Guest
I have imported information from Access where one of the fields contains
manual line breaks. It appears Excel converts the manual line break into a
square box. I would like to do a find and replace on these square boxes but
am having a hard time figuring out what code to use. I am thinking the ascii
code is either 10 or 13 for the mlb. So for the find field what would you
type? I have tried CHAR(10) and CHAR(13) but when it searches it says it
can't find the data I am searching for. I know I was able to accomplish this
a year or so ago but have since forgotten how to do it. Anyone have a
suggestion?
In general, if you are searching for symbols within an Excel file, how do
you indicate the ascii code in the "find what" field?
manual line breaks. It appears Excel converts the manual line break into a
square box. I would like to do a find and replace on these square boxes but
am having a hard time figuring out what code to use. I am thinking the ascii
code is either 10 or 13 for the mlb. So for the find field what would you
type? I have tried CHAR(10) and CHAR(13) but when it searches it says it
can't find the data I am searching for. I know I was able to accomplish this
a year or so ago but have since forgotten how to do it. Anyone have a
suggestion?
In general, if you are searching for symbols within an Excel file, how do
you indicate the ascii code in the "find what" field?