The TRIM function then removes all extra spaces and returns just the nth string.

You’ll find this feature on the Data tab of the ribbon in the Data Tools section.

For example, =MID(“apple”,2,3) returns “ppl”.

Excel formula: Get first word

SUBSTITUTE Function

The Excel SUBSTITUTE function replaces text in a given string by matching.

For example, =REPT(“x”,5) returns “xxxxx”.

LEN will also count characters in numbers, but number formatting is not included.

Excel formula: Get last word

Excel formula: Extract nth word from text string

Excel formula: Extract word that begins with specific character

Excel formula: Extract multiple lines from a cell

Excel formula: Abbreviate names or words

Excel formula: Split text and numbers

Excel formula: Split text string at specific character

Excel formula: Text split to array

Excel TRIM function

Excel MID function

Excel SUBSTITUTE function

Excel REPT function

Excel LEN function