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.

Zero2Hero — Zéro2Héros