+ Reply to Thread
Results 1 to 2 of 2

Cell Data Getting Cut Off When Pasted

  1. #1
    Registered User
    Join Date
    05-11-2012
    Location
    AZ
    MS-Off Ver
    Excel 2003
    Posts
    15

    Cell Data Getting Cut Off When Pasted

    I'm in the process of making a sample sheet for another question I am going to post up [funny how that works...], and I am copying and pasting highlighted cells into a fresh book. This has happened a few times in the past, and I can't remember how I fixed it.. if I ever did. The cells contain product descriptions.

    What they should look like:
    "Round Dual Tip Rear Muffler Volkswagen Golf II GTI 1.8L 16V 85+<br><br>Ranked number one in the world, Austrian manufacturer COMPANY is ahead of the game with their top of the line exhaust systems. At COMPANY, an exhaust is not simply built and put on the market. Each setup is rigorously tested not just for optimum performance, but for the highest quality sound attainable. If they are not perfect, the system is re-engineered and tested until the perfect balance between performance and sound is achieved. Every exhaust system is crafted from only the finest aluminum and steel, giving it the durability necessary to stand up to the rigors of various driving styles. <br><br>All systems are vehicle specific and easy to install as durable bolt-on systems. <br><br>Every system is EC approved, and TUV and ISO certified unless specified otherwise. <br><br>Fits Volkswagen Golf II GTI 1.8L 16V. Includes two round tips measuring 3.54". This muffler fits with and without a catalytic converter."

    What I get when pasted into the new book:
    "Round Dual Tip Rear Muffler Volkswagen Golf II GTI 1.8L 16V 85+<br><br>Ranked number one in the world, Austrian manufacturer COMPANY is ahead of the game with their top of the line exhaust systems. At COMPANY, an exhaust is not simply built and put on t"

    I know this is an issue when importing lengthy things from Access, but this is simply spreadsheet to spreadsheet. Any idea why this happens?

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,064

    Re: Cell Data Getting Cut Off When Pasted

    That's 254 characters.

    Excel 2003. There's prob a limit of 255 characters per cell though quick Google seems to suggest 32767 characters though only first 1024 are displayed.
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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