Getting characters from before and after a text
I have this value in a cell. I need some help to create a formula that can find the last '$' sign and get maximum of 4 number after the '$' sign and 6 numbers before the '$' sign from the data below.
"FB12345 $12345 ABCD 12345 SC
FB12346 $1234 ABCD 12345 SC
FB12347 $123 ABCD 12345 SC
FB12348 $12 ABCD 12345 SC"
The result I was expecting is "12348 $12"
Help Article Resources
Check out the Formula Handbook template!