ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   "Search" help (https://www.excelbanter.com/excel-discussion-misc-queries/78530-search-help.html)

davids

"Search" help
 
I am editing an excel database that has been worked on previously in either a
different format or under a different operating system so throughout the
spreadsheet characters such as "™‚" or various other shapes appear.I have
tried searching for these characters but excel returns a "Cannot find the
data you are searching for" message. is there anyway i can find and replace
these characters without manually scanning through the data?


Paul Lautman

"Search" help
 
davids wrote:
I am editing an excel database that has been worked on previously in
either a different format or under a different operating system so
throughout the spreadsheet characters such as "?" or various other
shapes appear.I have tried searching for these characters but excel
returns a "Cannot find the data you are searching for" message. is
there anyway i can find and replace these characters without manually
scanning through the data?


Works fine for me.
Can you post a copy of the sheet somewhere?




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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com