Sunday, 11 August 2013

Does Excel have Find & Replace match placeholder?

Does Excel have Find & Replace match placeholder?

I want to use wildcards in Excel Find & Replace dialog, to replace cells
with a pattern match. Made up example column:
_4
_44
_13
...
I want to replace these values with:
(4)
(44)
(13)
...
So I tried with _* which finds the pattern succesfully, but I couldn't
find anywhere if Excel features match placeholder. For example with regex
I would have used brackets and \1 as match placeholder. Does Excel have
this feature at all?

No comments:

Post a Comment