Using numbers from a pasted HTML table

  • Thread starter Thread starter Tom
  • Start date Start date
T

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
 
Try this Tom

Copy a empty cell
Select the cells
Right click on the selection
choose Paste Special
Check Add
Ok
 
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).
 
Back
Top