Find & Replace With Highlight & Wilcards

Susanto3311
3StarLounger
Posts: 240
Joined: 17 Feb 2022, 05:16

Find & Replace With Highlight & Wilcards

Post by Susanto3311 »

hi all..

how to use Find & Replace with wildcards..
i want to find & replace data with criteria like this:
1. my data into table. the data contains text and number;
2. before replace it, the text/number selected (drag/block manually);
3. to Replace, i use Highlight Format..

here attachment picture
how to solve this my problem
anyone help, thanks in advance

susant
You do not have the required permissions to view the files attached to this post.

User avatar
HansV
Administrator
Posts: 78457
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Find & Replace With Highlight & Wilcards

Post by HansV »

* stands for any number of characters, so *** is equivalent to *.
Perhaps you want to use ???
? stands for one character.
Best wishes,
Hans

Susanto3311
3StarLounger
Posts: 240
Joined: 17 Feb 2022, 05:16

Re: Find & Replace With Highlight & Wilcards

Post by Susanto3311 »

hi hans..
for word "Tidak" and "0" ----not work

User avatar
HansV
Administrator
Posts: 78457
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Find & Replace With Highlight & Wilcards

Post by HansV »

Please explain what you want to do.
Best wishes,
Hans

Susanto3311
3StarLounger
Posts: 240
Joined: 17 Feb 2022, 05:16

Re: Find & Replace With Highlight & Wilcards

Post by Susanto3311 »

i want to replace word selected /highlighted like my attachment :
word [Yes, 100, Tidak, 0] with 999..
that just sample.

User avatar
StuartR
Administrator
Posts: 12604
Joined: 16 Jan 2010, 15:49
Location: London, Europe

Re: Find & Replace With Highlight & Wilcards

Post by StuartR »

This seems to do what you want...
You do not have the required permissions to view the files attached to this post.
StuartR


User avatar
HansV
Administrator
Posts: 78457
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Find & Replace With Highlight & Wilcards

Post by HansV »

Try <*> in the 'Find what' box.
Best wishes,
Hans


Susanto3311
3StarLounger
Posts: 240
Joined: 17 Feb 2022, 05:16

Re: Find & Replace With Highlight & Wilcards

Post by Susanto3311 »

hi Hans & StuartR, thank you so much!! It's helped to me.