TRIM function

Excel » Functions » Text » TRIM function »

Extract k-th word in cell value

The formula displayed above in cell range D3:D9 extracts a word based its position in a cell value. For example, […]

How to use the TRIM function

The picture above shows you values that have multiple leading and trailing blanks, sometimes also between words. The TRIM function […]

Extract last word in cell

The formula demonstrated above in cell range C3:C9 extracts the last word from adjacent cell in column B. =TRIM(RIGHT(SUBSTITUTE(B3, " […]

Text to columns: Split words in a cell [Array formula]

This blog article describes how to split strings in a cell with space as a delimiting character, like Text to […]