Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Blank but not empty cell

  1. #1
    Guest

    Default

    Hi,
    I have imported data from an external file into excel. Some of the cells seems to be blank but obviously not empty!!
    They have length (4) and they do not "behave" as empty cells.
    How can I transform them to blanks?
    Eli

  2. #2
    New Member
    Join Date
    Feb 2002
    Location
    Dallas, Texas
    Posts
    33
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Try selecting Edit/Replace... from the main Excel menubar and type a single space in the Find What box, leave the Replace With box blank, and Replace All.

    This trick also works wonders when imported data refuses to plot correctly (spaces can cause all sorts of problems).

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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