[nfbcs] Replacing an ASCII Character with Another in Excel

[Sahar Husseini]

I am using a desktop.  The find and replace does not seem to recognize the characters when you use Alt and the combination of characters.  For example, when I type Alt 8217 in the find dialogue box, it is not found even though I know this is the ASCII character I want to replace.  I am using the number pad to do this.  Thanks.

Warm regards,
Sahar Husseini
For hand-crafted, one-of-a-kind jewelry, please visit my Website at
www.saharscreations.com
Find me on Facebook at www.facebook.com/saharscreations
And remember, "Obstacles don't have to stop you.
If you run into a wall, don't turn around and give up.
Figure out how to climb it, go through it, or work around it."
Michael Jordan
  ----- Original Message ----- 
  From: Nicole B. Torcolini at Home 
  To: NFB in Computer Science Mailing List 
  Sent: Saturday, September 17, 2011 11:54 AM
  Subject: Re: [nfbcs] Replacing an ASCII Character with Another in Excel


  Are you using a laptop or a desktop? This affects the answer.

  Nicole

  ----- Original Message ----- 
  From: "Sahar Husseini" <sahar at inebraska.com>
  To: "Multiple recipients of NFBnet NFBcs Mailing List" <NFBcs at NFBnet.org>
  Sent: Saturday, September 17, 2011 5:30 AM
  Subject: [nfbcs] Replacing an ASCII Character with Another in Excel


  > Hi,
  >
  > I have an Excel sheet that has a list of products.  When I export it to my 
  > Ecommerce software, the apostrophe will often appear as some weird square 
  > box.  I found out that the ASCII character for the apostrophe is 39, and 
  > the ASCII character for this weird box is 8217.  I want to replace all of 
  > the 8217 ASCII characters with ASCII 39.  The find and replace box isn't 
  > working for me.  Does anyone have any idea on how I would go about doing 
  > this?  I have 718 products.  Doing it by hand would be insane.  Thanks for 
  > any ideas.
  >
  > Warm regards,
  > Sahar Husseini
  > For hand-crafted, one-of-a-kind jewelry, please visit my Website at
  > www.saharscreations.com
  > Find me on Facebook at www.facebook.com/saharscreations
  > And remember, "Obstacles don't have to stop you.
  > If you run into a wall, don't turn around and give up.
  > Figure out how to climb it, go through it, or work around it."
  > Michael Jordan
  > _______________________________________________
  > nfbcs mailing list
  > nfbcs at nfbnet.org
  > http://nfbnet.org/mailman/listinfo/nfbcs_nfbnet.org
  > To unsubscribe, change your list options or get your account info for 
  > nfbcs:
  > http://nfbnet.org/mailman/options/nfbcs_nfbnet.org/ntorcolini%40wavecable.com 


  _______________________________________________
  nfbcs mailing list
  nfbcs at nfbnet.org
  http://nfbnet.org/mailman/listinfo/nfbcs_nfbnet.org
  To unsubscribe, change your list options or get your account info for nfbcs:
  http://nfbnet.org/mailman/options/nfbcs_nfbnet.org/sahar%40inebraska.com