Forum home » Delegate support and help forum » Microsoft Excel Training and help » financial excel course london - Trump cards
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
financial excel course london - Trump cards
Resolved · Low Priority · Version Standard
Reply Wed 3 Oct 2007, 09:43Delegate Minnaar said...
Minnaar has attended:
Excel Advanced course
Excel VBA Intro Intermediate course
Trump cards
I would like to use a sumif formula with not equalt to a certain word and I know one can use a trumpcard (or special character) to do this. What are all the trumpcards in excel?
For upcoming training course dates see: Pricing & availability
RE: Trump cards
Hi Minaar
Thank you for your question.
The trump cards, or wildcards as they are more commonly known, are ? (question mark) for a single character, e.g. organi?ation will find organisation and organization; and * (asterisk) for multiple characters, e.g. org* would find organise, organize, organising, organizing, organisation, organization and anything else that started with the letters org.
I hope this helps.
Amanda
|