return value between two $'s

[ammartino44]

Hello. How can I return the value between two $'s. For example, $X$12. I just want to return X, $AB$12 I want to return AB.

[bhenlee]

If your data is restricted to your examples then you can use this:

=IF(LEN(L35)>5,MID(L35,2,2),MID(L35,2,1))

[bhenlee]

You can use this for variations in your data:

=LEFT(MID(A2,2,100),(FIND("$",MID(A2,2,100),1)-1))

[FDibbins]

If your samples were meant to include =, then try this version, copied down...
=MID(A1,FIND("$",A1,1)+1,FIND("@",SUBSTITUTE(A1,"$","@",2),1)-2)

If your samples where meant to have = in front, that wont work, and Im not sure a regular formula will extract that for you either. Excel looks aty the results of a cell, not the actual contents (formulas etc)

[AlKey]

in B1 and copy down

=TRIM(MID(SUBSTITUTE(A1,"$",REPT(" ",5)),5,5))

Row\Col	A	B
1	$AB$12	AB
2	$X$12	X
3	$XFD$125	XFD

[ammartino44]

Thanks. Good examples.