How to replace ? to other value

[moonhkt]

Hi All

In Excel how to replace ? to other vlaue ?

In Menu Edit -> Repalce Find What and replace with.

e.g. "Multip?Price" to "Multip Price "

moonhkt

 

[Rick Rothstein]

The question mark is a wild card in the Find/Replace dialog, so you need to
"escape" it. The way to do that is by putting a tilde (~) in front of the
wild card character. So, use ~? in the "Find What" field (and it looks like
a space character in the "Replace With" field).

 

[moonhkt]

Thank It works.

The question mark is a wild card in the Find/Replace dialog, so you need to
"escape" it. The way to do that is by putting a tilde (~) in front of the
wild card character. So, use ~? in the "Find What" field (and it looks like
a space character in the "Replace With" field).

--
Rick (MVP - Excel)










- Åã¥Ü³Q¤Þ¥Î¤å¦r -