MrExcel Publishing
Your One Stop for Excel Tips & Solutions

html past into excel


Posted by Miguel on February 12, 2002 11:10 AM

I am trying to past my expense report that I retrieve from my intranet web site in html form in to excel which work perfectly but I'm unable to manipulate any of the data. ex: would be numeric fields want sum or do any arthimatic functions?

any help would be appreciated


Posted by Mark W. on February 12, 2002 1:24 PM

There's probably some special (unseen) characters
that are causing your number to be treated as
text. Use this formula...

=CODE(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1))

to obtain the ASCII coding of your value. Enter
it into an unused cell on your worksheet. Change
the "A1" to a cell reference of one of your
numeric values. Click on the formula bar and
press F9. Paste the resulting array constant
(e.g., {50;53;32}) into a reply posting.

Posted by Joe Clement on February 13, 2002 11:18 AM

I didn't post the original question but I'm having the same problem. I've followed your instructions and got this: ={160;54;51;48}

(the original value in the cell was: " 630")

What do I from here?