formula text to column filter $

[andi_wizard]

i have read "Text to Columns but using a formula" in other thread,

if I Have A1:

$K$failed OC/IC/SMS$

how i can filter using formula
B1: K
C1: failed OC/IC/SMS

I do not want to use VBA/code please.

please help and thanks before

[excelfandoo]

Formula on B1: =MID(A1,2,FIND("$",A1,2)-2)
Formula on C1: =MID(A1,FIND("$",A1,2)+1,FIND("$",A1,FIND("$",A1,2)+1)-FIND("$",A1,2)-1)

hope this helps.

[JBeaucaire]

B1: =trim(left(substitute(a1, "$", rept(" ", 30)), 50))
c1: =trim(right(substitute(a1, "$", rept(" ", 30)), 50))

[marryxiao]

i have read "Text to Columns but using a formula" in other thread,










fifa coins

[andi_wizard]

Thanks excelfandoo, jbeaucaore , marryxiao

Its very helps me