BeginnerAdministrationAbout 6 minutes
Sample data
| Row | A | B |
|---|---|---|
| 1 | Raw name | |
| 2 | amira HASSAN | [email protected] |
| 3 | ben CARTER | [email protected] |
| 4 | CHEN wei | [email protected] |
| 5 | dina ali | [email protected] |
Steps
Each formula is already filled in and calculated. Edit it and press Run to try your own version. Nothing is saved or uploaded.
See the problem: the first name has stray spaces. Count the characters.
Result
TRIM removes the extra spaces.
Result
PROPER fixes the capital letters.
Result
Do the same for the second name.
Result
Tidy the email: trim and make lower case.
Result
Pull the part before the @ out of the email.
Result
What to remember
Clean in a new column with formulas, then copy and paste as values over the old column. Never clean the only copy.
Need Something Different? Let’s Talk.
Looking for different features or something built around your workflow? Share your idea with us.