Unicode and Search and Replace

I have Excel 2003, and in a column I have various unicode Greek letters in
the Gentium font (such as ό) that I would like to search and replace into
numbers (ό would become 15) so I can sort the sheet (the search and replace
doesn't work for certain unicode Greek letters). Other than paying a lot for
an expensive add-on or other software product, is there any way I can do this
in Excel 2003? Please explain in simple English. Thanks.

Excel's usual Find / Replace can handle the job without addins.


1. put a single instance of any unicode character in an un-used cell
2. copy the cell
3. pull-down Edit > Find and paste into the findwhat field

you can then find and replace that character anywhere in the worksheet.
--
Gary's Student


"Rebecca" wrote:

> I have Excel 2003, and in a column I have various unicode Greek letters in
> the Gentium font (such as ό) that I would like to search and replace into
> numbers (ό would become 15) so I can sort the sheet (the search and replace
> doesn't work for certain unicode Greek letters). Other than paying a lot for
> an expensive add-on or other software product, is there any way I can do this
> in Excel 2003? Please explain in simple English. Thanks.

No, that doesn't work for Unicode characters. Any other ideas>

"Gary''s Student" wrote:

> Excel's usual Find / Replace can handle the job without addins.
>
>
> 1. put a single instance of any unicode character in an un-used cell
> 2. copy the cell
> 3. pull-down Edit > Find and paste into the findwhat field
>
> you can then find and replace that character anywhere in the worksheet.
> --
> Gary's Student
>
>
> "Rebecca" wrote:
>
> > I have Excel 2003, and in a column I have various unicode Greek letters in
> > the Gentium font (such as ό) that I would like to search and replace into
> > numbers (ό would become 15) so I can sort the sheet (the search and replace
> > doesn't work for certain unicode Greek letters). Other than paying a lot for
> > an expensive add-on or other software product, is there any way I can do this
> > in Excel 2003? Please explain in simple English. Thanks.

It certainly works for me when I replace Unicode

--
Regards,

Peo Sjoblom

(No private emails please)


"Rebecca" <Rebecca@discussions.microsoft.com> wrote in message
news:239694A7-6C28-4F4D-8586-E4D0618A3094@microsoft.com...
> No, that doesn't work for Unicode characters. Any other ideas>
>
> "Gary''s Student" wrote:
>
>> Excel's usual Find / Replace can handle the job without addins.
>>
>>
>> 1. put a single instance of any unicode character in an un-used cell
>> 2. copy the cell
>> 3. pull-down Edit > Find and paste into the findwhat field
>>
>> you can then find and replace that character anywhere in the worksheet.
>> --
>> Gary's Student
>>
>>
>> "Rebecca" wrote:
>>
>> > I have Excel 2003, and in a column I have various unicode Greek letters
>> > in
>> > the Gentium font (such as ό) that I would like to search and replace
>> > into
>> > numbers (ό would become 15) so I can sort the sheet (the search and
>> > replace
>> > doesn't work for certain unicode Greek letters). Other than paying a
>> > lot for
>> > an expensive add-on or other software product, is there any way I can
>> > do this
>> > in Excel 2003? Please explain in simple English. Thanks.