Replace commands in excel

Posted by lee Jackson on October 16, 2001 4:07 AM

Does anyone have the commands that can be used with the "replace" feature, especially the wildcard characters and commands.

Posted by Dan on October 16, 2001 4:26 AM

Is this what you are looking for?
Cells.Replace What:="abc123", Replacement:="xyz789", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False

Posted by Mark W. on October 16, 2001 10:56 AM

The wildcard characters are * (asterisk) and ?
(question mark). A question mark matches any
single character; an asterisk matches any
sequence of characters. If you want to find
an actual question mark or asterisk, type a tilde
(~) before the character. Wildcards are used
only in the Replace command's "Find what" field.