C cindee Oct 6, 2003 #1 How can I search for * in a spreadsheet? Everytime I put * in my search criteria, I get everything. Thanks, Cindee
How can I search for * in a spreadsheet? Everytime I put * in my search criteria, I get everything. Thanks, Cindee
P Paul Oct 6, 2003 #3 cindee said: How can I search for * in a spreadsheet? Everytime I put * in my search criteria, I get everything. Thanks, Cindee Click to expand... The asterisk is the wildcard character - that's why you get everything. To force Excel to treat it as a 'literal character', precede it with a tilde. So, search for ~*
cindee said: How can I search for * in a spreadsheet? Everytime I put * in my search criteria, I get everything. Thanks, Cindee Click to expand... The asterisk is the wildcard character - that's why you get everything. To force Excel to treat it as a 'literal character', precede it with a tilde. So, search for ~*
B Bernard Liengme Oct 6, 2003 #4 Hi Cindee, In the Find What enter ~* (tilde is next to 1 on top row of 'typewriter' keys) I looked in Help under 'wildcard' Bernard
Hi Cindee, In the Find What enter ~* (tilde is next to 1 on top row of 'typewriter' keys) I looked in Help under 'wildcard' Bernard
