Administration and Executive AssistantTier 245 minintermediate

Text Splitting and Joining

Break concatenated strings and reassemble them.

What you will learn

• Use TEXTSPLIT for delimited text (modern Excel)
• Use TEXT and CONCATENATE or & operator
• Understand TEXTJOIN for joining with separators
• Handle TEXTSPLIT in older Excel versions with formulas

Excel skills

TEXTSPLIT, TEXT, CONCATENATE, &, TEXTJOIN · Text Transformation

The task

Fifteen addresses, split across Unit, Street, Suburb, City and Postal Code columns because that is how the property system exports them. I need a single Full Address field for the courier's label printer, comma-separated, in that order.

You work in a real spreadsheet in your browser, and your answer is checked against hidden traps the moment you submit.

Try this lesson free