Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old August 3rd 05, 09:39 AM
Bill Ridgeway
 
Posts: n/a
Default Searching for "?"

It seems that Excel is unable to find the character ?. It stops at every
cell.

Are there any other characters which it can't find and, more importantly how
can Excel be persuaded to search for "?" ?

Thanks.

Bill Ridgeway
Computer Solutions



  #2   Report Post  
Old August 3rd 05, 09:43 AM
Niek Otten
 
Posts: n/a
Default

Search for "~?"

--
Kind regards,

Niek Otten

Microsoft MVP - Excel


"Bill Ridgeway" wrote in message
...
It seems that Excel is unable to find the character ?. It stops at every
cell.

Are there any other characters which it can't find and, more importantly
how can Excel be persuaded to search for "?" ?

Thanks.

Bill Ridgeway
Computer Solutions




  #3   Report Post  
Old August 3rd 05, 09:53 AM
Bill Ridgeway
 
Posts: n/a
Default

Niek,

Many thanks for that. But why should I know that to search for "?" I must
type in "~?". (Are there any others like this?) It seems most illogical
and counter intuitive. Is there a valid reason for this or is this another
example of Microsoft being inconsistent? (Why click on start when you want
to turn off the computer? rhetoric.)

Regards.

Bill Ridgeway
Computer Solutions

"Niek Otten" wrote in message
...
Search for "~?"

--
Kind regards,

Niek Otten

Microsoft MVP - Excel


"Bill Ridgeway" wrote in message
...
It seems that Excel is unable to find the character ?. It stops at every
cell.

Are there any other characters which it can't find and, more importantly
how can Excel be persuaded to search for "?" ?

Thanks.

Bill Ridgeway
Computer Solutions






  #4   Report Post  
Old August 3rd 05, 10:35 AM
Niek Otten
 
Posts: n/a
Default

From HELP:

You can use wildcard characters such as an asterisk (*) or a question mark
(?) in your search criteria:



Use the asterisk to find any string of characters. For example, s*d finds
"sad" and "started".

Use the question mark to find any single character. For example, s?t finds
"sat" and "set".

Note You can find asterisks, question marks, and tilde characters (~) in
worksheet data by preceding them with a tilde character in the Find what
box. For example, to find data that contains "?", you would type ~? as your
search criteria.


--
Kind regards,

Niek Otten

Microsoft MVP - Excel



"Bill Ridgeway" wrote in message
...
Niek,

Many thanks for that. But why should I know that to search for "?" I must
type in "~?". (Are there any others like this?) It seems most illogical
and counter intuitive. Is there a valid reason for this or is this
another example of Microsoft being inconsistent? (Why click on start when
you want to turn off the computer? rhetoric.)

Regards.

Bill Ridgeway
Computer Solutions

"Niek Otten" wrote in message
...
Search for "~?"

--
Kind regards,

Niek Otten

Microsoft MVP - Excel


"Bill Ridgeway" wrote in message
...
It seems that Excel is unable to find the character ?. It stops at
every cell.

Are there any other characters which it can't find and, more importantly
how can Excel be persuaded to search for "?" ?

Thanks.

Bill Ridgeway
Computer Solutions










Reply
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
searching for specific criteria and then doing an action based on Bill Excel Discussion (Misc queries) 1 July 20th 05 03:55 AM
searching for multiple text strings eddie Excel Discussion (Misc queries) 4 April 10th 05 10:15 PM
Searching based on Text color EbonyMonarch Excel Worksheet Functions 1 February 15th 05 02:51 PM
Searching a list with repeat entries and creating a sum Brian Connolly Excel Discussion (Misc queries) 1 February 3rd 05 09:41 PM
Formula for Searching & matching two values in excel Chris Excel Discussion (Misc queries) 1 January 7th 05 04:34 PM


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

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017