Forum Discussion

Copper Contributor

Mar 10, 2020

Covert two lines to two columns

I have some data as follows: Header1: Data A Header2: Data B Header1: Data A Header2: Data B Header1: Data A Header2: Data B I'm sure this is very simple to do, but I can't work out how. H...

excel

adlih

Copper Contributor

Mar 11, 2020

AngelaMR

IF "Header1: Data A" IN BOX A1, "Header2: Data B" IN BOX A2,

THEN FOR BOX B2 PLS ENTER:

=LEFT(A1,(FIND(":",A1)-1))&" | "&LEFT(A2,(FIND(":",A1)-1))

THEN FOR BOX B3 PLS ENTER:
=RIGHT(A1,(FIND(":",A1)-1))&" | "&RIGHT(A2,(FIND(":",A1)-1))