View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jim Rech
 
Posts: n/a
Default How can I search for *?

Using Edit, Replace search for ~*

--
Jim
"gjcase" wrote in
message ...
|
| I have a large imported list of part numbers. The problem is that some
| of the part numbers contain an asterisk (*) as part of the part number.
| This causes some obvious problems when doung lookups. I'd like to do a
| search/replace to replace all asterisks with some other non-wild-card
| symbol.
|
| Can anyone tell me how to do this?
|
| Thanks.
|
| ---Glenn
|
|
| --
| gjcase
| ------------------------------------------------------------------------
| gjcase's Profile:
http://www.excelforum.com/member.php...o&userid=26061
| View this thread: http://www.excelforum.com/showthread...hreadid=512793
|