Dashboard Mode - Text to columns
Goal
Split full names into first and last names to organize contact data better.
0
0
Text to columns in Excel - Dashboard Guide
Sample Data
| Full Name | Phone |
|---|---|
| John Smith | 555-1234 |
| Mary Johnson | 555-5678 |
| David Lee | 555-8765 |
| Linda Brown | 555-4321 |
| James Wilson | 555-6789 |
Dashboard Components
- Original Data Table: Shows full names and phone numbers as entered.
- Split Columns: Two new columns created by Text to Columns feature:
- First Name (e.g., John)
- Last Name (e.g., Smith)
- Count of Contacts: A cell showing total number of contacts using formula
=COUNTA(A2:A6)which returns 5.
Dashboard Layout
+----------------------+----------------+----------------+----------------+ | Original Data | First Name | Last Name | Count of | | (Full Name, Phone) | (Split Column) | (Split Column) | Contacts | +----------------------+----------------+----------------+----------------+ | John Smith | John | Smith | Total: 5 | | Mary Johnson | Mary | Johnson | | | David Lee | David | Lee | | | Linda Brown | Linda | Brown | | | James Wilson | James | Wilson | | +----------------------+----------------+----------------+----------------+
Interactivity
The Text to Columns feature is a one-time action that splits the full name text into two columns based on the space delimiter. After splitting, the data can be filtered or sorted by first or last name separately. For example, filtering last names starting with 'S' will update the visible rows in the split columns and original data.
Self Check
If you add a filter to show only last names starting with 'J', which rows remain visible in the split columns and original data?
Answer: The row with Mary Johnson remains visible.
Key Result
Dashboard shows how to split full names into first and last names using Text to Columns and count contacts.