IntermediateHRAbout 6 minutes
Sample data
| Row | A | B | C | D | E |
|---|---|---|---|---|---|
| 1 | Name | Department | Salary | Start date | Rating |
| 2 | Amira Hassan | Finance | 9200 | 2019-03-04 | 4 |
| 3 | Ben Carter | Sales | 7800 | 2021-07-19 | 3 |
| 4 | Chen Wei | Sales | 8100 | 2020-01-13 | 5 |
| 5 | Dina Ali | HR | 7200 | 2022-09-01 | 4 |
| 6 | Emil Novak | Operations | 6900 | 2018-11-26 | 2 |
| 7 | Farah Khan | Finance | 10400 | 2016-05-09 | 5 |
| 8 | Gabriel Silva | Operations | 6500 | 2023-02-14 | 3 |
Steps
Each formula is already filled in and calculated. Edit it and press Run to try your own version. Nothing is saved or uploaded.
Find the space between the names.
Result
Take everything before the space for the first name.
Result
Take everything after the space for the last name.
Result
Build initials from both.
Result
Put them back together as “Last, First”.
Result
What to remember
FIND locates the separator; LEFT and MID cut around it. The same idea splits codes, emails and addresses.
Need Something Different? Let’s Talk.
Looking for different features or something built around your workflow? Share your idea with us.