Symbol Conversion?

K

Ken

Excel 2000 ... My column contains the following ... How do
I clean, format or otherwise convert (or whatever?) these
various symbols in order to achieve just plain text?
(Note: the various brackets are ok ... The issue is the A
with the symbol on top & the AE crunched together) ...
Thanks ... Kha.

[ Å | Æ .001 | A | E ]
1.501-1.503 THICKNESS
4.497-4.499 I.D.
[ Å | Æ .001 | A | E ]
2.253-2.263 HEIGHT
..780-.790 HEIGHT
..295-305 THICKNESS
17.158-17.162 I.D.
[ Å | Æ .002 | A | J ]
5.195-5.205 O.D.
 
K

Ken

More info ... Cell contents originally created in WORD
using Symbols which had different FONTS. Word then pasted
to Excel where cell contents now contains Symbols with
mulitple Font Styles. I did not know how to correct other
than to select each cell ... then each symbol ... & then
select the correct font for the symbol ... Thanks ... Kha

-----Original Message-----
Excel 2000 ... My column contains the following ... How do
I clean, format or otherwise convert (or whatever?) these
various symbols in order to achieve just plain text?
(Note: the various brackets are ok ... The issue is the
A
with the symbol on top & the AE crunched together) ...
Thanks ... Kha.

[ Å | Æ .001 | A | E ]
1.501-1.503 THICKNESS
4.497-4.499 I.D.
[ Å | Æ .001 | A | E ]
2.253-2.263 HEIGHT
..780-.790 HEIGHT
..295-305 THICKNESS
17.158-17.162 I.D.
[ Å | Æ .002 | A | J ]
5.195-5.205 O.D.

.
 
Top