Microsoft has introduced 14 new Excel text and array manipulation functions that you can use in Office. These 14 new Excel functions are designed to help manipulate text and arrays,
and make it easier to extract and split text as well as combine and shape data.See the new Functions at https://insider.office.com/en-gb/blog/text-and-array-manipulation-functions-in-excel