Using numbers from a pasted HTML table

[Tom]

Hi, I have pasted an HTML table from a website into my
spreadsheet. When I reference the cells that appear to
contain numbers the formula =(E1+H1)/J1 results in #VALUE.
I formatted the "J" column as number to no avail. How can I
get excel to recognise these cells as numbers?
Thanks Tom

 

[Ron de Bruin]

Try this Tom

Copy a empty cell
Select the cells
Right click on the selection
choose Paste Special
Check Add
Ok

 

[Jim]

Many times there are additional characters in HTML. You need to remove them
using the TRIM function. Here's a test: Look at a cell to see how many
characters there are. Then in a separate cell, use the formula
=LEN(ThatCell).