Microsoft has released four awesome new text functions into Excel
All four are really useful additions to the Excel function set, simplifying the way we tackle data analysis and financial modelling challenges. Let's have a look at each of them in turn.
The TEXTJOIN function concatenates (or joins) values together from cells or ranges of cell.
This function is a great improvement on the CONCAT and CONCATENATE functions as it allows you to include a delimiter and to choose whether or not to ignore empty cells.
See our full article on the TEXTJOIN function here.
TEXTSPLIT splits a text string by using column and row delimiters. The TEXTSPLIT function works the same as text to column, but in a formula rather than through a wizard. It allows you to split across columns and/or down by rows.