Home › Learn Excel › Lesson 12
Join text from several cells, fix capitals, remove extra spaces and replace characters.
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 C2PROPER 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 B2TRIM 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 B2SUBSTITUTE swaps a piece of text for another piece, everywhere it appears. Replace the dashes in the phone number with spaces, in B2