View Single Post
 
Old 04-12-2021, 11:58 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, FNR Wildcards Amounts in tables Cells alone

I need Help again, Pro's

Well insights!

I know how to do a wildcard research. And I know that in cells, it must ends by:
Chr(7) + Chr(13)

So why can't I find in 1 or All Tables Cells, having only amounts of money, with or without $ sign, for all instance of:
[0-9, $]{1;} + Chr(7) + Chr(13) ?

Doesn't do anything. I've tried to find the Chr codes for numbers from 0-9, and tested in one cell with the number 2 so Chr(50), it didn't do anything.

I've tried as well, Chr(50) & Chr(7) + Chr(13) vs Chr(50) + Chr(7) + Chr(13) [& vs + after the (50), didn't do anything].

So can it be done? If so, what am I doing wrong?

Cendrinne
Reply With Quote