Excel wildcard ? for replacing strings in dropdown function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When I use the find/replace the "?" replaces characters in a string. Example:

Cells: abcd, abdf, abxs, abrd.....
Find: ab?? Replace with :bc?? This results with all cells: bc??

How can I use the wildcard so that the results of the replace are: bccd,
bcdf, bcxs, bcrd... without having Excel replace the last part of the string
with ??. I can't find a help screen that describes this option ? in
repplacing. This work fine in WORD.
 

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

Wildcard in the Replace function 2
Use of Wildcard characters with replace 2
Replace with wildcards 2
Replacing using a wildcard 2
Why not accept wildcards for REPLACE as well as FIND ? 5
"Find" a wildcard as a place marker and "replace" with original va 1
How to Find/Replace * (asterisk) in cell content 4
Find and Replace Command Using Wildcard Help 1

Back
Top