LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Gary''s Student
 
Posts: n/a
Default Unicode and Search and Replace

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.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
getting unicode to convert from PC to MAC not a programmer Excel Discussion (Misc queries) 3 February 26th 05 01:27 AM


All times are GMT +1. The time now is 06:08 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"