J
JaxHBT
When I download contact address information from Outlook to an XL file, many
times there appears a square 'box' character in the cell where either (a) a
comma would have been separating street from say, suite # in the same line or
(b) where a return would have been (street address <return> city/state/zip)
in the address card. I have tried to search and replace to change or delete
the character, but I am unable to grab it, and thus have to manually adjust
each cell. A daunting task with 4000+ entries....
The box character only appears in the formula field bar -- when viewing the
cell in the sheet, it appears as two vertical lines (like a double lower case
L).
What is this character called how do I get rid of it??? Thx
times there appears a square 'box' character in the cell where either (a) a
comma would have been separating street from say, suite # in the same line or
(b) where a return would have been (street address <return> city/state/zip)
in the address card. I have tried to search and replace to change or delete
the character, but I am unable to grab it, and thus have to manually adjust
each cell. A daunting task with 4000+ entries....
The box character only appears in the formula field bar -- when viewing the
cell in the sheet, it appears as two vertical lines (like a double lower case
L).
What is this character called how do I get rid of it??? Thx