Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to paste data containing html
i work for a retail company with ecommerce website and need to upload our
product data to an online shopping service. i have a problem where all of the main item descriptions have formatting such as <p <br <li ect. i need to make universal changes to every item description. FYI - the product data for each product is on ONE line. when i do an edit - replace all in excel i am told the "Forlula is too Long" then when i copy the data to a text editor, perform the changes and paste it back to the spreadsheet, it pastes but actually uses the <P and <BR tags as a webpage woul there fore spreading my data over numerous lines. please help, ive got 5500 lines of data to do |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stop excel from processing HTML? IE paste raw html. | Excel Discussion (Misc queries) | |||
if i cut and paste from html into excel, i cannot create formulas | Excel Discussion (Misc queries) | |||
How can I cut data out of HTML table, into msExcel and just take the data & columns? (but NOT the formatting & URLs!) | Excel Discussion (Misc queries) | |||
How to paste html code to xls | Excel Discussion (Misc queries) | |||
Excel 2003 SP2 hangs on HTML paste | Excel Discussion (Misc queries) |