| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Search for foreign characters
Hi,
Is it possible to do a search on all foreign characters in an excel spreadsheet? Is there a particular function that I need to use? Thanks. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Search for foreign characters
It depents on which kind of search result you require.
Using the MATCH function (enter 1 as thirth parameter) you get the last cell row containing the found character. Hope this helps! - Bas Isa wrote: Hi, Is it possible to do a search on all foreign characters in an excel spreadsheet? Is there a particular function that I need to use? Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I search and replace special characters in Excel e.g. „¢ | Excel Discussion (Misc queries) | |||
| build a search tool in excel | Excel Discussion (Misc queries) | |||
| Search for Square Characters | Excel Discussion (Misc queries) | |||
| Autofilter to search characters that begin with "* " | Excel Discussion (Misc queries) | |||
| FAQ Spreadsheet with search function | Excel Discussion (Misc queries) | |||
Linear Mode
