Library Workshops

Excel Intermediate - Learning Objective #5:

Using Text Formulas:

Skills and concepts covered:

• UPPER
• PROPER
• LOWER
• CONCATENATE

Activities:

• On the Data Worksheet put your cursor in B3 → from the formula bar select fx (insert function) → search for UPPER → select UPPER → in the text field enter A3, hit ok → use the autofill cursor to extend the formula to B7

• On the Data Worksheet put your cursor in C3 → from the formula bar select fx (insert function) → search for PROPER → select PROPER → in the text field enter B3, hit ok → use the autofill cursor to extend the formula to C7
• On the Data Worksheet put your cursor in D3 → from the formula bar select fx (insert function) → search for LOWER → select LOWER → in the text field enter C3, hit ok → use the autofill cursor to extend the formula to D7
• On the OrderForm worksheet, put cursor in cell C3 → from the formula bar select fx (insert function) → search for CONCATENATE → select CONCATENATE → enter B3 for Text1 → enter “, “ [quote comma space end quote] for Text2 → enter A3 for Text3 → use the autofill cursor to extend the formula for the entire "customer full name" column.