TechTalkz.com Logo Ask the Experts!

Go Back   TechTalkz.com Technology & Computer Troubleshooting Forums > Tech Support Archives > Microsoft > Microsoft Office

How to detect symbol/special character code.

Microsoft Office

 
 
Thread Tools Display Modes
Unread 26-09-2007, 06:59 PM   #1
Jeff Ingman
Guest
 
Posts: n/a
How to detect symbol/special character code.

I often find symbols in MS documents I'd like to remove or replace with
something else.

Is there a way to detect the underlying code of a symbol or special
character to use for "Search and Replace"?
 
Unread 26-09-2007, 06:59 PM   #2
Herb Tyson [MVP]
Guest
 
Posts: n/a
Re: How to detect symbol/special character code.

Usually, if you copy one of the target characters to the clipboard, you can
paste it into the Find what: field and it will work just fine.

Many special characters can also be inserted into Find what: or Replace
with: by clicking the More>> button in the Find and Replace dialog box, and
then clicking Special.

--
Herb Tyson MS MVP
Author of the Word 2007 Bible
Blog: http://word2007bible.herbtyson.com
Web: http://www.herbtyson.com


"Jeff Ingman" <JeffIngman@discussions.microsoft.com> wrote in message
news:C263CB75-D839-4034-9947-B60A7F14B311@microsoft.com...
>I often find symbols in MS documents I'd like to remove or replace with
> something else.
>
> Is there a way to detect the underlying code of a symbol or special
> character to use for "Search and Replace"?


 
Unread 26-09-2007, 06:59 PM   #3
Jeff Ingman
Guest
 
Posts: n/a
Re: How to detect symbol/special character code.

Thanks for the post Herb.

I use your suggestion below when it works... but I sometimes run across
symbols that do copy/paste into the search/replace boxes.

And in the case I ran across this morning I could not find a specific symbol
in the "special characters' box... (which I do not find in Excel by the
way... only in Word).

The character looked like a little squre box... but the sides were either
missing or very faint... sort of like a square bullet but it was something
else.

jeff

"Herb Tyson [MVP]" wrote:

> Usually, if you copy one of the target characters to the clipboard, you can
> paste it into the Find what: field and it will work just fine.
>
> Many special characters can also be inserted into Find what: or Replace
> with: by clicking the More>> button in the Find and Replace dialog box, and
> then clicking Special.
>
> --
> Herb Tyson MS MVP
> Author of the Word 2007 Bible
> Blog: http://word2007bible.herbtyson.com
> Web: http://www.herbtyson.com
>
>
> "Jeff Ingman" <JeffIngman@discussions.microsoft.com> wrote in message
> news:C263CB75-D839-4034-9947-B60A7F14B311@microsoft.com...
> >I often find symbols in MS documents I'd like to remove or replace with
> > something else.
> >
> > Is there a way to detect the underlying code of a symbol or special
> > character to use for "Search and Replace"?

>
>

 
Unread 26-09-2007, 07:01 PM   #4
Herb Tyson [MVP]
Guest
 
Posts: n/a
Re: How to detect symbol/special character code.

If you know the character code for it, you can search using ^[character
code] (e.g., ^0124). If you don't have any idea how it was inserted and if
it doesn't survive pasting, then it's hard to know what to tell you. You
might try looking at the Insert Symbol offerings to see if you can figure
out what the character code for it is.

--
Herb Tyson MS MVP
Author of the Word 2007 Bible
Blog: http://word2007bible.herbtyson.com
Web: http://www.herbtyson.com


"Jeff Ingman" <JeffIngman@discussions.microsoft.com> wrote in message
news:8440AF6F-074B-4D4F-B22A-B3DB8AEBE021@microsoft.com...
> Thanks for the post Herb.
>
> I use your suggestion below when it works... but I sometimes run across
> symbols that do copy/paste into the search/replace boxes.
>
> And in the case I ran across this morning I could not find a specific
> symbol
> in the "special characters' box... (which I do not find in Excel by the
> way... only in Word).
>
> The character looked like a little squre box... but the sides were either
> missing or very faint... sort of like a square bullet but it was something
> else.
>
> jeff
>
> "Herb Tyson [MVP]" wrote:
>
>> Usually, if you copy one of the target characters to the clipboard, you
>> can
>> paste it into the Find what: field and it will work just fine.
>>
>> Many special characters can also be inserted into Find what: or Replace
>> with: by clicking the More>> button in the Find and Replace dialog box,
>> and
>> then clicking Special.
>>
>> --
>> Herb Tyson MS MVP
>> Author of the Word 2007 Bible
>> Blog: http://word2007bible.herbtyson.com
>> Web: http://www.herbtyson.com
>>
>>
>> "Jeff Ingman" <JeffIngman@discussions.microsoft.com> wrote in message
>> news:C263CB75-D839-4034-9947-B60A7F14B311@microsoft.com...
>> >I often find symbols in MS documents I'd like to remove or replace with
>> > something else.
>> >
>> > Is there a way to detect the underlying code of a symbol or special
>> > character to use for "Search and Replace"?

>>
>>


 
Unread 26-09-2007, 07:02 PM   #5
Jeff Ingman
Guest
 
Posts: n/a
Re: How to detect symbol/special character code.

Thanks Herb...

Another poster suggested I use the "Code=" function to get the number for
the code I want to replace. The number returned is 13. But when I enter
"^013" in the replace box and hit replace... I get a message saying Excel
cannot find any data to replace.

"Herb Tyson [MVP]" wrote:

> If you know the character code for it, you can search using ^[character
> code] (e.g., ^0124). If you don't have any idea how it was inserted and if
> it doesn't survive pasting, then it's hard to know what to tell you. You
> might try looking at the Insert Symbol offerings to see if you can figure
> out what the character code for it is.
>
> --
> Herb Tyson MS MVP
> Author of the Word 2007 Bible
> Blog: http://word2007bible.herbtyson.com
> Web: http://www.herbtyson.com
>
>
> "Jeff Ingman" <JeffIngman@discussions.microsoft.com> wrote in message
> news:8440AF6F-074B-4D4F-B22A-B3DB8AEBE021@microsoft.com...
> > Thanks for the post Herb.
> >
> > I use your suggestion below when it works... but I sometimes run across
> > symbols that do copy/paste into the search/replace boxes.
> >
> > And in the case I ran across this morning I could not find a specific
> > symbol
> > in the "special characters' box... (which I do not find in Excel by the
> > way... only in Word).
> >
> > The character looked like a little squre box... but the sides were either
> > missing or very faint... sort of like a square bullet but it was something
> > else.
> >
> > jeff
> >
> > "Herb Tyson [MVP]" wrote:
> >
> >> Usually, if you copy one of the target characters to the clipboard, you
> >> can
> >> paste it into the Find what: field and it will work just fine.
> >>
> >> Many special characters can also be inserted into Find what: or Replace
> >> with: by clicking the More>> button in the Find and Replace dialog box,
> >> and
> >> then clicking Special.
> >>
> >> --
> >> Herb Tyson MS MVP
> >> Author of the Word 2007 Bible
> >> Blog: http://word2007bible.herbtyson.com
> >> Web: http://www.herbtyson.com
> >>
> >>
> >> "Jeff Ingman" <JeffIngman@discussions.microsoft.com> wrote in message
> >> news:C263CB75-D839-4034-9947-B60A7F14B311@microsoft.com...
> >> >I often find symbols in MS documents I'd like to remove or replace with
> >> > something else.
> >> >
> >> > Is there a way to detect the underlying code of a symbol or special
> >> > character to use for "Search and Replace"?
> >>
> >>

>
>

 
Unread 26-09-2007, 09:00 PM   #6
Herb Tyson [MVP]
Guest
 
Posts: n/a
Re: How to detect symbol/special character code.

Excel's Find/Replace works differently... Usually ^013 would correspond to a
paragraph break. =Code(cell address) returns the code only of the first
character in a string. So, it would find the code for the odd character only
if it were the only or first characer in the cell.

If you can put just that character into a cell and then evaluation it, you
can try searching. Let's say the code is "114". Rather than searching for
^114, click in Find what:, turn NumLock on, hold down the Alt key, and type
114 (on the number pad). It will insert the character that corresponds to
that code (and it might look differently, since font formatting isn't
performed in the Find what: text field, so you'll likely see the ANSI/ASCII
character from the basic set.

If this techniques works within Excel, you might try pasting the mystery
character(s) from Word into Excel, using CODE to determine the value, and
then try either ^code or the Alt+entry method for inserting it into Word's
Find what: box.

If this doesn't get you what you want, you might try
microsoft.public.excel.misc or one of the other Excel groups.

--
Herb Tyson MS MVP
Author of the Word 2007 Bible
Blog: http://word2007bible.herbtyson.com
Web: http://www.herbtyson.com


"Jeff Ingman" <JeffIngman@discussions.microsoft.com> wrote in message
news:FB3D4100-139B-49D0-85C9-8D68A04EBF23@microsoft.com...
> Thanks Herb...
>
> Another poster suggested I use the "Code=" function to get the number for
> the code I want to replace. The number returned is 13. But when I enter
> "^013" in the replace box and hit replace... I get a message saying Excel
> cannot find any data to replace.
>
> "Herb Tyson [MVP]" wrote:
>
>> If you know the character code for it, you can search using ^[character
>> code] (e.g., ^0124). If you don't have any idea how it was inserted and
>> if
>> it doesn't survive pasting, then it's hard to know what to tell you. You
>> might try looking at the Insert Symbol offerings to see if you can figure
>> out what the character code for it is.
>>
>> --
>> Herb Tyson MS MVP
>> Author of the Word 2007 Bible
>> Blog: http://word2007bible.herbtyson.com
>> Web: http://www.herbtyson.com
>>
>>
>> "Jeff Ingman" <JeffIngman@discussions.microsoft.com> wrote in message
>> news:8440AF6F-074B-4D4F-B22A-B3DB8AEBE021@microsoft.com...
>> > Thanks for the post Herb.
>> >
>> > I use your suggestion below when it works... but I sometimes run across
>> > symbols that do copy/paste into the search/replace boxes.
>> >
>> > And in the case I ran across this morning I could not find a specific
>> > symbol
>> > in the "special characters' box... (which I do not find in Excel by the
>> > way... only in Word).
>> >
>> > The character looked like a little squre box... but the sides were
>> > either
>> > missing or very faint... sort of like a square bullet but it was
>> > something
>> > else.
>> >
>> > jeff
>> >
>> > "Herb Tyson [MVP]" wrote:
>> >
>> >> Usually, if you copy one of the target characters to the clipboard,
>> >> you
>> >> can
>> >> paste it into the Find what: field and it will work just fine.
>> >>
>> >> Many special characters can also be inserted into Find what: or
>> >> Replace
>> >> with: by clicking the More>> button in the Find and Replace dialog
>> >> box,
>> >> and
>> >> then clicking Special.
>> >>
>> >> --
>> >> Herb Tyson MS MVP
>> >> Author of the Word 2007 Bible
>> >> Blog: http://word2007bible.herbtyson.com
>> >> Web: http://www.herbtyson.com
>> >>
>> >>
>> >> "Jeff Ingman" <JeffIngman@discussions.microsoft.com> wrote in message
>> >> news:C263CB75-D839-4034-9947-B60A7F14B311@microsoft.com...
>> >> >I often find symbols in MS documents I'd like to remove or replace
>> >> >with
>> >> > something else.
>> >> >
>> >> > Is there a way to detect the underlying code of a symbol or special
>> >> > character to use for "Search and Replace"?
>> >>
>> >>

>>
>>


 
 

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to detect symbol/special character code. Jeff Ingman Microsoft Office 4 26-09-2007 06:57 PM
Special character as admin username - cannot find it from keyboard Mark Helmin Windows Vista All 3 17-09-2007 08:02 PM
Special Character, need of WGD Microsoft Office 20 08-09-2007 09:00 PM
Special Character WGD Windows XP 4 08-09-2007 04:02 AM
Vista Special Character Conversion Mohsin Windows Vista All 0 17-08-2007 09:57 AM


< Home - Windows Help - MS Office Help - Hardware Support >


New To Site? Need Help?

All times are GMT. The time now is 08:14 PM.


vBulletin, Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO
Copyright © 2005-2013, TechTalkz.com. All Rights Reserved - Privacy Policy
Valid XHTML 1.0 Transitional