Viewing hidden characters

  • Thread starter Thread starter BT Connect
  • Start date Start date
B

BT Connect

I have a list of addresses where the wholw address is contained in a single
cell, with each element of the address separated by a CR and LF character
which appear as squares. When I view the same data on another computer,
with the same version of Excel (2003) the squares don't appear.

Does anyone know the setting to display or hide these characters?

Jeff
 
Don't think this is an interface setting but occurs after installing
the later service packs on XL2002/3, the extra characters are still
stored in the cell but just don't display.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Replace weird character 2
Hide non-printing characters. 5
Problem importing data from Access 2
Viewing Control Characters 3
Square character(s) in cells 2
Square-box character in data import 10
Cut and Paste Text with CRLF into Single Cell 1
how to replace an unrecognised character 2

Back
Top