[nfbcs] Replacing an ASCII Character with Another in Excel

Nicole B. Torcolini at Home ntorcolini at wavecable.com
Sun Sep 18 02:02:50 UTC 2011


Not a problem. Glad that I could help.

----- Original Message ----- 
From: "Sahar Husseini" <sahar at inebraska.com>
To: "NFB in Computer Science Mailing List" <nfbcs at nfbnet.org>
Sent: Saturday, September 17, 2011 6:47 PM
Subject: Re: [nfbcs] Replacing an ASCII Character with Another in Excel


> Lol, that was so simple.  I'm not sure why I didn't think of that.  I 
> thought it would just see it as an apostrophe, but it really does not, 
> even though Window-Eyes does say apostrophe--fascinating.  Thank you very 
> much for the suggestion.  Of course, some of my descriptions are too long, 
> so Excel stopped me from replacing all of them by saying that formula was 
> too long, but I just had to do it manually.  I don't know if there is a 
> way around this "formula is too long" message.  I get that when I 
> spell-check or find and replace, but that's another problem to tackle. 
> Thanks again for the suggestion.  I really appreciate it.  Sometimes, the 
> simplest things don't occur to us.  *grin*
>
> 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: Sahar Husseini
>  To: NFB in Computer Science Mailing List
>  Sent: Saturday, September 17, 2011 8:39 PM
>  Subject: Re: [nfbcs] Replacing an ASCII Character with Another in Excel
>
>
>  Hmm, I have not.  Let me see what that does.  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 8:26 PM
>    Subject: Re: [nfbcs] Replacing an ASCII Character with Another in Excel
>
>
>    Have you tried copying and pasting the symbol?
>
>    ----- Original Message ----- 
>    From: "Sahar Husseini" <sahar at inebraska.com>
>    To: "NFB in Computer Science Mailing List" <nfbcs at nfbnet.org>
>    Sent: Saturday, September 17, 2011 11:30 AM
>    Subject: Re: [nfbcs] Replacing an ASCII Character with Another in Excel
>
>
>    >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
>    > _______________________________________________
>    > 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
>  _______________________________________________
>  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
> _______________________________________________
> 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 





More information about the NFBCS mailing list