Remove letters and leave numbers only

I have a cell with the following formula: ="$ "&ROUND(J62/6;2)&" no interest"

The number in bold is the problem. I have to divide by 4, 5 and 6. I manually input the number six. I would like it to be automatic. But since the sheet is full of other things and change all the time, the best scenario would be to take this number from the previous column which have exactly like this:

4x
5x
6x

So if there is a formula to replace the number six (in bold) and put a formula that will gather 6x and make it be 6, would be great.

Thanks.

Originally Posted by sandy666

try ="$ "&ROUND(J62/LEFT(I62);2)&" no interest"

I assume
4x
5x
6x
are in appropriate cells, 62, 63, 64.... or change I62 accordingly

Thank you! That works perfectly!

Originally Posted by etaf

can you attach a sample spreadsheet please

how will the formula know to use 6 or 5 or 4 ?
you can use the indirect() function to take a value from a cell and use in a formula

Each number has its specific line. Each line have 4x, 5x, 6x. The only problem was to remove the X and put the number into the formula. Thanks anyway!

You are welcome , thanks for rep. Have a nice day