Extract Characters from 1 string in separate cells

[samrat_castle]

I have a JSON text result from an API, given below.

{"visit":"1","paid":"0","repeatPat":0}

I need the numbers to be extracted in 3 separate cells. Please assist.

 

[Rick Rothstein]

Assuming that text value is in cell A1, put this formula in cell B1 and copy across...

=TRIM(MID(SUBSTITUTE(":"&SUBSTITUTE(SUBSTITUTE(SUBSTITUTE($A1,",",":"),"""",""),"}",""),":",REPT(" ",100)),200*COLUMNS($B:B),100))

 

[samrat_castle]

Thanks! It's working great!