View Single Post
 
Old 11-13-2020, 09:40 AM
Cendrinne's Avatar
Cendrinne Cendrinne is offline Windows 10 Office 2019
Competent Performer
 
Join Date: Aug 2019
Location: Montreal Quebec Canada
Posts: 200
Cendrinne is on a distinguished road
Default Help with WildCards Find & Replace either or nothing...

I need help, insights. Been searching for answers, even here in the forum of already discussed, and I don't seem to find it.

I've recently learned how to put different options in the last box, example below :

[0-9]{1;}[*,.] // [\(][0-9]{1;}[\)][*,.]

What I'm searching for is: 2, 4, 5 // (space then numbers 0-9, with a comma, and just a number at the end.)

Would be the same thing with (2), (4), (5).// (same explanation as above, exept with a parenthese).

and / or
either a space before or nothing, then (4), (5), (6), (7) /// (NO space before the (4))

So what am I to do, when the last digit needs no coma or )? I thought the * would resolve this, since it's 0 charactere or more than 1, but it ignores the last digit in a cell.

BTW, these are at the end of the cells, are like references, where I want to delete them.

Any help? What am I doing wrong?

Cendrinne
Reply With Quote