Hi,

Assuming data string in A1...

Use B1 formula copied across if you want results horizontal,

Use A2 formula copied down if you want results vertical:

A B C D E 1 {"date": 5/7/19 headline:"GE Posts Profit" source:"CNBC"}{"date": 5/8/19 headline:"GE Dividend Shrink" source:"MSN"}{"date": 5/9/19 headline:"GE Bankrupt" source:"WSJ"} GE Posts Profit GE Dividend Shrink GE Bankrupt 2 GE Posts Profit 3 GE Dividend Shrink 4 GE Bankrupt 5 Sheet661

Worksheet Formulas

Cell Formula B1 =TRIM(SUBSTITUTE(MID(SUBSTITUTE(SUBSTITUTE($A1,"headline:",REPT(" ",LEN($A1))),"source:",REPT(" ",LEN($A1))),(COLUMNS($B1:B1)*2-1)*LEN($A1),LEN($A1)),CHAR(34),"")) A2 =TRIM(SUBSTITUTE(MID(SUBSTITUTE(SUBSTITUTE(A$1,"headline:",REPT(" ",LEN(A$1))),"source:",REPT(" ",LEN(A$1))),(ROWS(A$2:A2)*2-1)*LEN(A$1),LEN(A$1)),CHAR(34),""))

## Like this thread? Share it with others