Excel: joining and cleaning text
Sign up free to unlock this topic
Kindergarten is free, and guests can try one sample topic in every other grade. A free parent or teacher account opens every topic from Kindergarten to Grade 12, college and university, and saves progress. No credit card.
Try the free sample: The ideal gas law · Have a class or homeroom code? Join here
Key idea: Excel: joining and cleaning text
& joins text: =A2&" "&B2. LEFT, RIGHT and MID take pieces; UPPER, LOWER and PROPER change capitals; TRIM removes extra spaces. Functions can be nested, inside out.
Key words
- LEFT(text, 3)
- The first 3 characters.
- TRIM
- Cleans spaces before and after, and doubles.
🔎 What to look for: Spaces you can't see often break lookups: TRIM first.
