Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Oct 2005
    Location
    Cambridgeshire, USA
    Posts
    109
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Space in letter shows as box (2003)

    Hello,

    I downloaded some information and it seems that the cell is formatted as text, but the display shows a box everytime there is a space in the letterson that cell. I tried to copy it to another cell, but the box still remains. Is there a way to find change this without having to retype it. I tried to use format cells, but that didn't work. Any help would be great. Thanks.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Space in letter shows as box (2003)

    Are ALL spaces displayed as boxes? If so, what font has been used?

    It might be a line feed; you can check this as follows:
    - Select one or some of the cells,
    - Select Format | Cells...
    - Activate the Alignment tab.
    - Tick the "Wrap text" check box.
    - Click OK.
    If the boxes disappear, they are line breaks.

  3. #3
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Space in letter shows as box (2003)

    Another way of working out what the character means is to use the code function. I use to have to do downloads from some old legacy systems and this character appeared all the time. I usually found it was a char(10) or char(13) character which the old system saw as a line feed or carriage return.

    Say the character is the second character in the string in cell A1 you could use the following function to see what character value it is and then do a find and replace:

    =CODE(MID(A1,2,1))
    Jerry

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •