How to replace ? to other value

  • Thread starter Thread starter moonhkt
  • Start date Start date
M

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
 
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).
 
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 -
Click to expand...
 
Back
Top