Suppose cell A$1$ contains a string representing a ticker symbol and the corresponding

price $($e$.$g$.$ FB $$74\mathrm{.}31,$ AAPL $$134\mathrm{.}67).$ What is the correct formula to extract the price of

the stock. Note that the number representing the price could be any number of digits.

Check all correct answers.

MID$($A$1,$FIND$("",$A$1),$LEN$($A$1))$

RIGHT$($A$1,6)$

MID$($A$1,3,$LEN$($A$1))$

RIGHT$($A$1,$LEN$($A$1)-$FIND$("",$A$1))$