Menu

Tech

English

Recap: Working with Text

Part of the Fundamentals section of Coddy's Excel journey. Lesson 33 of 42.

Challenge

Easy

The name Ada Lovelace is split across A2 (first) and B2 (last). Generate two account fields:

C2, username: the first name, a dot, the last name, all in small letters (ada.lovelace)
D2, badge code: the first 3 letters of the last name, in capitals (LOV)

A second person is tested with the same formulas, build everything from the cells.

Try it yourself

Sheet1

	A	B	C	D	E	F	G
1	First	Last	Username	Badge
2	Ada	Lovelace
3
4
5
6
7
8
9
10
11
12
13
14

All lessons in Fundamentals

1Meet the Spreadsheet

What Is a Spreadsheet?Cells and References Your First Cells Rows, Columns and the Grid Recap: Meet the Grid

4Cell References

Referencing Other Cells Formulas That Update Chained Formulas Ranges from A1 to A10 Recap: Cell References

7Decisions with IF

The IF Function Writing an IF Comparison Operators Nested IFs Recap: Decisions with IF

2Entering Data

Text and Numbers Building a Small Table Editing and Clearing Cells Numbers That Mean Something Recap: Entering Data

5Basic Functions

What Is a Function The SUM Function The AVERAGE Function MIN and MAX COUNT and COUNTA Combining Functions Recap: Basic Functions

8Project: Grade Book

Grade Book Setup Totals and Averages Pass or Fail with IF Finishing the Grade Book

3Your First Formula

What Is a Formula?Writing a Formula Formulas with Cells Arithmetic Operators Order of Operations Recap: First Formulas

6Working with Text

Joining Text UPPER and LOWER Measuring Text with LEN LEFT, RIGHT and MIDRecap: Working with Text