[nfbcs] Replacing an ASCII Character with Another in Excel
Sahar Husseini
sahar at inebraska.com
Sun Sep 18 01:47:51 UTC 2011
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
More information about the NFBCS
mailing list