View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Find * and Replace

Same thing with
? use ~?
* use ~*
~ use ~~

mrbalaje wrote:

In a excel spreadsheet i want to find * and replace it with "" (null). But
when i find * identifies every letter in the spreadsheet and clear my
spreadsheet. Can someone suggest me the way to acheive this.

Let say I have
1
2
*
3
4

I want to replace * from the column to blank "". Please suggest me a way.


--

Dave Peterson