| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pasted HTML Table Data Won't Convert From Text
When copying a table from a webpage, the numeric data pastes into Excel as
text. Normally, I can easily convert "text digits" by simply clicking in each cell (as if to edit) or doing a search/replace, looking for one character (a common digit, decimal point) and replacing it with the same. That method isn't working with the HTML-originated data, which refuses to convert itself unless it's re-typed. What is it about this data type that makes it so stubborn? TIA |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pasted HTML Table Data Won't Convert From Text
It's common for ranges pasted from web pages to contain HTML non-breaking
spaces. Try this to remove them: Select the range of "numbers" <Edit<Replace Find What: [Alt]+0160 <-Hold down [Alt]€¦type 0160€¦release [Alt] Replace with: (leave this blank) Click [Replace All] Does that help? *********** Regards, Ron XL2002, WinXP "Eric" wrote: When copying a table from a webpage, the numeric data pastes into Excel as text. Normally, I can easily convert "text digits" by simply clicking in each cell (as if to edit) or doing a search/replace, looking for one character (a common digit, decimal point) and replacing it with the same. That method isn't working with the HTML-originated data, which refuses to convert itself unless it's re-typed. What is it about this data type that makes it so stubborn? TIA |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pasted HTML Table Data Won't Convert From Text
I just discovered the spaces before seeing your answer, and wondered why they
were invulnerable to automatic deletion with a find/replace command. Thanks,works like a charm! "Ron Coderre" wrote: It's common for ranges pasted from web pages to contain HTML non-breaking spaces. Try this to remove them: Select the range of "numbers" <Edit<Replace Find What: [Alt]+0160 <-Hold down [Alt]€¦type 0160€¦release [Alt] Replace with: (leave this blank) Click [Replace All] Does that help? *********** Regards, Ron XL2002, WinXP "Eric" wrote: When copying a table from a webpage, the numeric data pastes into Excel as text. Normally, I can easily convert "text digits" by simply clicking in each cell (as if to edit) or doing a search/replace, looking for one character (a common digit, decimal point) and replacing it with the same. That method isn't working with the HTML-originated data, which refuses to convert itself unless it's re-typed. What is it about this data type that makes it so stubborn? TIA |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Unable to delete html data pasted into a cell | Excel Discussion (Misc queries) | |||
| pasted HTML text disappears | Excel Discussion (Misc queries) | |||
| How to convert HTML data into Excel? | Excel Discussion (Misc queries) | |||
| HTML Table pasted to Excel | Excel Discussion (Misc queries) | |||
| Convert excel table to HTML | Excel Discussion (Misc queries) | |||
Hybrid Mode
