Results 1 to 2 of 2

How to edit contents in Cell

Threaded View

hrukmini How to edit contents in Cell 05-11-2008, 10:01 PM
Mikeopolo Try the Trim formula? 05-11-2008, 10:36 PM
  1. #1
    Registered User
    Join Date
    06-20-2007
    Posts
    14

    How to edit contents in Cell

    I have a huge data base with names and address. (see screen shot of the Excel sheet)

    If you can see the contents of Cell A 887, you would notice that it contains two characters which look like a square. However if you see the contents of the same cell in the Formula Bar you would not see this square characters.

    To remove these characters from the cell, I need to individually go to each cell and in the formula bar I have place the cursor at the end of the contents and then click "DELETE" a couple of times so that this character disappears.

    This is time consuming and I need to know whether I can delete this characters at one go. I have already tried the "FIND AND REPLACE" option, but it does not work, for the simple reason that this characters does not show up in the formula bar at all.

    Any help please?
    Attached Images Attached Images

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1