Did you spot the new Excel functions?

I’m already using them extensively. This is not an instruction article. You should rather watch a UTube video.

I just want to be sure that you are aware of them, because I only found out from my daughter who is an Excel specialist.

So, Goodbye =A23&” “&B23&” “&C23

Hello =TEXTJOIN(” “,TRUE,A23:C23)

TEXTSPLIT saves a lot more difficult formulation by separating text into individual cells

TEXTSPLIT(I6,” “) separates the contents of I6 which is Derek Peter Springett into  J6 Derek K6 Peter L6 Springett. that one is a winner, because I could never remember how to write a formula to do it.