How to split the given text

Question

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

dexterg_iii · Answer

Rfire777&nbsp;=TEXTSPLIT(TEXTBEFORE(A2,"_")&amp;"*"&amp;TEXTAFTER(A2,"_"),"*")of course, replace the cell references with the cell containing the source text&nbsp;&nbsp;

peterbartholomew1 · Answer

Rfire777&nbsp;I would probably use= HSTACK(
    TEXTBEFORE(string, "_"),
    TEXTAFTER(string,"_")
  )

harun24hr · Answer

Rfire777&nbsp;Excel for web and desktop O365-=TEXTSPLIT(SUBSTITUTE(A1,"_","|",1),"|")&nbsp;For Excel 2013 and later-=FILTERXML("&lt;t&gt;&lt;s&gt;"&amp;SUBSTITUTE(A1,"_","&lt;/s&gt;&lt;s&gt;",1)&amp;"&lt;/s&gt;&lt;/t&gt;","//s[1]")
=FILTERXML("&lt;t&gt;&lt;s&gt;"&amp;SUBSTITUTE(A1,"_","&lt;/s&gt;&lt;s&gt;",1)&amp;"&lt;/s&gt;&lt;/t&gt;","//s[2]")Excel older than 2013-=LEFT(A1,SEARCH("_",A1)-1)
=MID(A1,SEARCH("_",A1)+1,100)&nbsp;

Forum Discussion

How to split the given text

3 Replies

Resources