如何取15262.17值?

evg

~83.49~85.22~84.01~1080021~518598~561421~83.48~11~83.47~33~83.46~22~83.45~23~83.44~19~83.49~161~83.50~837~83.51~166~83.52~35~83.53~278~~20200123155903~-1.73~-2.03~84.56~82.48~83.49/1080021/9019354016~1080021~901935~1.00~9.69~~84.56~82.48~2.44~9044.19~15262.17~2.38~93.74~76.70~1.56~-1369~83.51~8.83~14.21~~~1.13~901935.40~0.00~0~ ~GP-A~-2.31~~2.21~24.57~2.22"

evg

正侧行不通?

evg

已解决!
=TRIM(MID(SUBSTITUTE($C4,"~",REPT(" ",50)),300,50))

Kaohsing

好像股票或者基金的数据，split就可

evg

arr = Split(strText, "~")
Cells(2, 2) = arr(2)