Skip to main content

Library Workshops

Excel Intermediate - Learning Objective #5

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.

Telephone416-864-5059 Email icon hslibrary@smh.ca           Twitter icon   Health Sciences Library Blog                Health Sciences Library Feedback