+ Reply to Thread
Results 1 to 2 of 2

Remove character from excel cells

  1. #1
    Registered User
    Join Date
    01-21-2007
    Posts
    3

    Unhappy Remove character from excel cells

    Hi,
    I am uploading my products to my website using a .csv file in microsoft excel 2007. In the description column all of my cells are in HTML. In each one of the cells there is a character that is causing errors when using Goooooogle Checkout. There is a picture below showing what the character is. Can someone tell me how to remove the character without having to go to each individual cell. I have already tried "find and replace" but that doesn't work.

    html_error.jpg

    Thanks,
    Jeff
    AVSiPod.com

  2. #2
    Registered User
    Join Date
    01-21-2007
    Posts
    3

    Found the Solution

    I found the solution to my question.

    What I needed to do was simply "clean up" my cells. I did this by using a formula. To cleanup a cell -

    1. Click an empty cell next to the cell you wish to "clean".
    2. Enter =CLEAN(cell you wish to clean) into the formula bar.
    3. Thats it!

+ Reply to Thread

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