Category: Text

Functions

Excel TRIM function

237 Views
The TRIM function removes excess spacing from text strings, leaving just a singular space in between words and no spaces …
Functions

Excel CONCATENATE Function

394 Views
The ‘CONCATENATE’ function in Excel will amalgamate a series of selected cells into one text string. This formula can be …
Functions

Excel LEN Function

443 Views
The ‘LEN’ function in Excel will return the length (i.e. number of characters) of a given text/numerical string. Whilst the …