No. of Recommendations: 0
Hey Fools,

My stock watchlist resides in Google Sheets. I like it a lot, but I'm trying to pull in data from to make it even more useful.

I'm made some progress, but I've encountered a problem and I'm currently stumped.

I'm trying to be able to sort my companies by growth rate. To do so, I first need to pull in data on what the companies' growth rate is.

I found some code that lets me pull in estimated EPS growth over the next five years from Finviz.

Here is that code(where "&B2" = the stock ticker):

=index(IMPORTHTML(""&B2,"table&quo..., 11),6,6)

In this example, the stock ticker that I'm looking at is PAYC. When I plug in this formula, I get the following result:


This is almost exactly what I want because that is the estimated 5-year EPS growth rate for Paycom from this table:

However, the problem I am facing now is that the format doesn't allow me to sort. Google Sheets doesn't see *21.51%* as a number. Instead, it sees it as just text.

What I would love to be able to do is turn *21.51%* into the clean number 21.51%.

I've tried =CLEAN() and =TRIM(), but those don't fix the problem.

Does anyone know what I can do (or another board that I can post this question to)?

Many thanks!

Print the post  


What was Your Dumbest Investment?
Share it with us -- and learn from others' stories of flubs.
When Life Gives You Lemons
We all have had hardships and made poor decisions. The important thing is how we respond and grow. Read the story of a Fool who started from nothing, and looks to gain everything.
Contact Us
Contact Customer Service and other Fool departments here.
Work for Fools?
Winner of the Washingtonian great places to work, and Glassdoor #1 Company to Work For 2015! Have access to all of TMF's online and email products for FREE, and be paid for your contributions to TMF! Click the link and start your Fool career.