Change cell format

[travislynk]

Very simple question.

If I wanted to change an existing cell "Down 0.32 (19.63%)"

And I want to change it to "19.63"

How would I go about doing it?

**I want to be able to fill this formaula down a column, and all of the cells will be ending in "%)"

Thank you.

 

[Andrew Poulsom]

Try:

=SUBSTITUTE(RIGHT(A1,LEN(A1)-FIND("(",A1)),")","")*100

 

[travislynk]

Works great, thank you.

Is it too complicated to explain?

 

[Andrew Poulsom]

The formula takes the text to the right of the opening parenthesis, removes the closing parenthesis and multiplies by 100.