JPMCC 2012-1 A1

Prepay %
Loss %
Credit Support
ETC...

MLMTI 2014-6 B4

Prepay %
Loss %
Credit Support
ETC...

JPMCC 2012-1 A1
MLMTI 2014-6 B4

B1: =FIND(" ", A1)
C1: =LEFT(A1, B1 - 1)

D1: =EXACT(UPPER(C1), C1)

E1: =FIND(" ", A1, B1 + 1)
F1: =MID(A1, B1 + 1, E1 - B1 - 1)

G1: =LEFT(F1, 4) - 0

H1: IFERROR(IF((B1+E1+LEN(C1)+LEN(F1)+G1+D1)*0=1,"",A1),"")