ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how do I import a large amount of text into one cell? (https://www.excelbanter.com/excel-discussion-misc-queries/62660-how-do-i-import-large-amount-text-into-one-cell.html)

Avid Marine

how do I import a large amount of text into one cell?
 
I am trying to build a product database to upload to a new web site. I have
to copy and paste descriptions fom various websites to begin with. I cannot
seem to maintain orginal formats from the websites such as bullet points,
etc. So can anyone tell me what the best method is for this? Also once I do
have the product description, I have to paste into Excel so I can then
convert to a "csv" file which is used by the web hosting service. When I
paste a description into an excel cell, it covers up the entire worksheet! I
know that excel can handle a few thousand characters, but even if my
character count is roughly 500, it seems to overflow into the entire
worksheet. Is there a format I need to know about here? Thanks for your
help.


All times are GMT +1. The time now is 07:49 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com