Find * and Replace
 

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.

Find * and Replace
 

Use ~* to search

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"mrbalaje" wrote in message ...
| 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.

Find * and Replace
 

Edit Replace FindWhat: ~* ReplaceWith: nothing, leave blank
ReplaceAll

Vaya con Dios,
Chuck, CABGx3



"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.

Find * and Replace
 

Use

~*

as your find string

Mike

"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.

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