Archive for 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, […]
The picture above shows you values that have multiple leading and trailing blanks, sometimes also between words. The TRIM function […]
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 […]
