Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel TRIM() can't handle in pasted HTML
Has anyone seen this kind of misbehavior?
1. Create a table in HTML like: <table<tr <td align="right" nowrap214,074 </td <td align="right" nowrap55,859 </td <td align="right" nowrap26.09 </td <td align="right" nowrap267,102 </td <td align="right" nowrap71,365 </td <td align="right" nowrap26.72 </td </tr</table (this is actually created by a very silly application we bought) 2. Display it in your favorite browser 3. Copy it into an Excel spreadsheet 4. try to trim() or value() any of the values to get a number. Doesn't work! What works is '=value(a1,len(a1)- 1) !!!! |
#2
|
|||
|
|||
=substitute(a1,CHAR(160),"")
-- HTH RP (remove nothere from the email address if mailing direct) "dyt" wrote in message ... Has anyone seen this kind of misbehavior? 1. Create a table in HTML like: <table<tr <td align="right" nowrap214,074 </td <td align="right" nowrap55,859 </td <td align="right" nowrap26.09 </td <td align="right" nowrap267,102 </td <td align="right" nowrap71,365 </td <td align="right" nowrap26.72 </td </tr</table (this is actually created by a very silly application we bought) 2. Display it in your favorite browser 3. Copy it into an Excel spreadsheet 4. try to trim() or value() any of the values to get a number. Doesn't work! What works is '=value(a1,len(a1)- 1) !!!! |
#3
|
|||
|
|||
"dyt" wrote in message ... Has anyone seen this kind of misbehavior? 1. Create a table in HTML like: <table<tr <td align="right" nowrap214,074 </td <td align="right" nowrap55,859 </td <td align="right" nowrap26.09 </td <td align="right" nowrap267,102 </td <td align="right" nowrap71,365 </td <td align="right" nowrap26.72 </td </tr</table (this is actually created by a very silly application we bought) 2. Display it in your favorite browser 3. Copy it into an Excel spreadsheet 4. try to trim() or value() any of the values to get a number. Doesn't work! What works is '=value(a1,len(a1)- 1) !!!! Why not simply open the html page in notepad and do a find and replace on  ? /Fredrik |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I isolate my Excel server (automation) from other Excel instances? | Excel Discussion (Misc queries) | |||
Using Excel to analyze HTML | Excel Discussion (Misc queries) | |||
VB Automation is Whacking out my Excel Environment | Excel Discussion (Misc queries) | |||
HTML to Excel | Excel Discussion (Misc queries) | |||
excel CSV is interpreted as HTML | Excel Discussion (Misc queries) |