How to Replace ? With Space
 

Dear Experts!

I have a data like Below mentioned
Hardeep?kanwar
Hardeep?kanwar
pai kanwar?
renu kanwar
pai?Kanwar

Now i want to Replace ? mark with Single Space

I try Ctrl+H
Find What: ?
Replace With: Space
but Delete the All the Data

Pls help me

How to Replace ? With Space
 

Hi,

Excel is teating ? as a wildcard so to make it a literal character used a
tilde

search for ~?

Mike

"Hardeep kanwar" wrote:

Dear Experts!

I have a data like Below mentioned
Hardeep?kanwar
Hardeep?kanwar
pai kanwar?
renu kanwar
pai?Kanwar

Now i want to Replace ? mark with Single Space

I try Ctrl+H
Find What: ?
Replace With: Space
but Delete the All the Data

Pls help me

How to Replace ? With Space
 

Thanks for the Quick Reply

Works like a Magic

Hardeep kanwar



"Mike H" wrote:

Hi,

Excel is teating ? as a wildcard so to make it a literal character used a
tilde

search for ~?

Mike

"Hardeep kanwar" wrote:

Dear Experts!

I have a data like Below mentioned
Hardeep?kanwar
Hardeep?kanwar
pai kanwar?
renu kanwar
pai?Kanwar

Now i want to Replace ? mark with Single Space

I try Ctrl+H
Find What: ?
Replace With: Space
but Delete the All the Data

Pls help me

How to Replace ? With Space
 

Why not try following?
If data is in A1, then

in cell B1, type
=substitute(a1,"?"," ")

hsg

"Hardeep kanwar" wrote:

Dear Experts!

I have a data like Below mentioned
Hardeep?kanwar
Hardeep?kanwar
pai kanwar?
renu kanwar
pai?Kanwar

Now i want to Replace ? mark with Single Space

I try Ctrl+H
Find What: ?
Replace With: Space
but Delete the All the Data

Pls help me