Forum Discussion

Copper Contributor

Oct 01, 2022

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

excel

Excel for web

PeterBartholomew1

Silver Contributor

Oct 01, 2022

Rfire777

I would probably use

= HSTACK(
    TEXTBEFORE(string, "_"),
    TEXTAFTER(string,"_")
  )