Forum Discussion
How to split the given text
Hi Everyone! How can i split the text with two hyphen but need the result in only two parts, 1st is the two letter code and in second column need the rest of the text as shown in attached photo
=TEXTSPLIT(TEXTBEFORE(A2,"_")&"*"&TEXTAFTER(A2,"_"),"*")of course, replace the cell references with the cell containing the source text