Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Solutions Through Learning

Excellent

Request Callback We will call you back

0207 987 3777 Call for assistance

Your Basket Basket is empty

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel.advanced.course - Formulas

excel.advanced.course - Formulas

ResolvedVersion Standard

Wed 9 Jan 2008, 11:27 Delegate Beatriz said...

Beatriz has attended:
No courses

Formulas

Can you choose a range including text AND numbers in the same cell when entering a criteria ?

Fri 11 Jan 2008, 17:15 Trainer Amanda said...

RE: Formulas

Hi Beatriz

Thank you for your question.

Could you please provide some more detail about what you are wanting to use the criteria for? This will help me to better answer your question.

Thanks in advance
Amanda

Excel tip:

Validating text entries

1. Select the range of cells.
2. From the Data menu, select Validation.
3. Select the Settings tab.
4. From the Allow dropdown list, select Custom.
5. In the Formula box, enter the following formula: