+ Reply to Thread
Results 1 to 3 of 3

Excel Cell Not Showing Full Data

  1. #1
    Registered User
    Join Date
    04-05-2012
    Location
    KP
    MS-Off Ver
    Excel 2016
    Posts
    67

    Excel Cell Not Showing Full Data

    Hi, Thanks for checking my Thread.
    In a particular CSV Excel file I want to populate "Description" column with a HTML template Code by merging 3 columns of HTML. The HTML has almost 20,000 characters. Now before merging and after merging when I copy paste the HTML in any cell it doesn't show all the code that I have copied. and when I merge all the 3 columns. a lot of HTML data seems to be missing. I think excel has some sort of limit and it is not allowing all these 20,000 characters merged and combined in 1 cell. I am stuck at this point and can't upload the CSV as the HTML is missing a lot of coding. Any solution please?
    Thanks

  2. #2
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.95 for Mac MS 365
    Posts
    8,682

    Re: Excel Cell Not Showing Full Data

    Just using simple copy and paste excel will limit the content of a cell to 255 characters. If you use copy and paste special >> values it will take in a lot more for the cell content though I'm sure there is an upper limit on that too.
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci

  3. #3
    Registered User
    Join Date
    04-05-2012
    Location
    KP
    MS-Off Ver
    Excel 2016
    Posts
    67

    Re: Excel Cell Not Showing Full Data

    Thanks so much Sambo Kid. Problem is solved now..

    Thanks again

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Scroll Bars and Worksheet Tabs Only Showing in Full Screen Mode
    By Boo123 in forum Excel General
    Replies: 2
    Last Post: 01-28-2013, 02:14 PM
  2. Data entry after last full cell
    By elevisse in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-02-2013, 08:20 AM
  3. graphic element showing %age water tank is full
    By James C in forum Excel General
    Replies: 2
    Last Post: 09-10-2009, 03:49 PM
  4. Replies: 3
    Last Post: 08-12-2008, 03:56 AM
  5. Worksheets Not Showing Until User Click On Full View?
    By Redtail50 in forum Excel General
    Replies: 1
    Last Post: 04-28-2008, 11:49 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1