Extract three value and put each one in different cell

[mazan2010]

Dear All
i have the following value in Specific cell and want to extract each value in different cell
for example
V=18731, S=19833, A=18915 in Q2
and want to extract Value of V in B8 ( cell B8 will be 18731)
and extract Value of S in B9 ( cell B9 will be 19833)
and extract Value of A in B10 ( cell B10 will be 18915 )

[MarvinP]

Hi mazan,

See if something like this works for you.

=MID(TRIM(MID(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE($Q$2,",",""),"=","")," ",REPT(" ",100)),1+(100*(ROW()-8)),100)),2,100)
Parse out 3 numbers.xlsx