LEFT, RIGHT, MID in Google Sheets - Dashboard Guide

Dashboard Mode - LEFT, RIGHT, MID

Dashboard Goal

This dashboard helps you understand how to extract parts of text strings using the LEFT, RIGHT, and MID functions in Google Sheets. You will see how to get the first few letters, last few letters, or letters from the middle of a text.

Sample Data

Full Name	LEFT (First 5 chars)	RIGHT (Last 4 chars)	MID (Chars 4 to 8)
Jonathan Smith	=LEFT(A2,5)	=RIGHT(A2,4)	=MID(A2,4,5)
Emily Johnson	=LEFT(A3,5)	=RIGHT(A3,4)	=MID(A3,4,5)
Michael Brown	=LEFT(A4,5)	=RIGHT(A4,4)	=MID(A4,4,5)
Sarah Davis	=LEFT(A5,5)	=RIGHT(A5,4)	=MID(A5,4,5)
David Wilson	=LEFT(A6,5)	=RIGHT(A6,4)	=MID(A6,4,5)

Dashboard Components

• KPI Cards: Show examples of LEFT, RIGHT, MID formulas with sample text and their results.
• Example Table: Displays full names and the extracted text parts using the formulas:
• LEFT(A2,5) extracts first 5 characters from the name.
• RIGHT(A2,4) extracts last 4 characters from the name.
• MID(A2,4,5) extracts 5 characters starting from the 4th character.

Dashboard Layout

+----------------------+----------------------+----------------------+
|      Full Name       |     LEFT (5 chars)   |    RIGHT (4 chars)   |
+----------------------+----------------------+----------------------+
| Jonathan Smith       | Jonat                | mith                 |
| Emily Johnson        | Emily                | nson                 |
| Michael Brown        | Micha                | rown                 |
| Sarah Davis          | Sarah                | avis                 |
| David Wilson         | David                | lson                 |
+----------------------+----------------------+----------------------+

+----------------------+----------------------+
|       MID (4,5)      |   Explanation Cards   |
+----------------------+----------------------+
| athan                | LEFT(text, num_chars) |
| ly Jo                | RIGHT(text, num_chars)|
| hael                 | MID(text, start, len) |
| ah Da                |                      |
| id Wi                |                      |
+----------------------+----------------------+

Interactivity

You can change the number of characters to extract by editing the formulas in the table. For example, change LEFT(A2,5) to LEFT(A2,3) to get the first 3 letters. The results update automatically.

This helps you explore how LEFT, RIGHT, and MID work with different lengths and positions.

Self Check

Add a filter to show only names starting with 'S'. Which rows update in the table? What are the LEFT, RIGHT, and MID results for those names?

Key Result

A dashboard showing how to use LEFT, RIGHT, and MID functions to extract parts of text strings in Google Sheets.