Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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 | |
|
|
![]() |
||||
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) |