Learn Excel
EN
Sets how numbers, dates and formulas look, so everything works just like your own Excel.

Home › Learn Excel › Lesson 12

Combine and clean up text in Excel

Join text from several cells, fix capitals, remove extra spaces and replace characters.

  1. Join text: &. CONCATENATE joins text from several cells. Add a space between quotes to keep the words apart. Join the first and last name into one full name in C2
  2. Capitals: PROPER. PROPER starts every word with a capital letter and makes the rest lower case. Give the name a capital at the start of each word, in B2
  3. Extra spaces: TRIM. TRIM removes spaces at the start and end of a text, and turns double spaces in the middle into one. Clean up the extra spaces in the name, in B2
  4. Join with a space.
  5. Your turn: SUBSTITUTE. SUBSTITUTE swaps a piece of text for another piece, everywhere it appears. Replace the dashes in the phone number with spaces, in B2

← All lessons