How to Replace ? With Space

H

Hardeep kanwar

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
 
M

Mike H

Hi,

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

search for ~?

Mike
 
H

hsg

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

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

hsg
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top