Excel 2021 cell limit

Page 3 of 4 FirstFirst 1234 LastLast

  1. Posts : 323
    Windows 10 Home 64 bit x64 Version 22H2
    Thread Starter
       #21

    comcom said:
    Thanks for all comments.

    Example: I copied and pasted all the text from 1996 California Proposition 218 - Wikipedia into excel B2 cell but not all text are pasted in because each cell has character limit. Excel auto cuts off the rest of the text when it reaches limit.

    In the future I will select the B2 cell and read the text in B2 cell displayed at the top box. I usually only read long text at top box as I find it easier to read long text there.

    This is how it looks like when I click once B2 cell to select B2 cell using my mouse and the B2 cell contents is displayed at top box

    I will click once inside the top box and press page down until the end to see the last character it allows. Not all the information is pasted in due to character limit. This is how it looks like

    (For your info, at the top box, dragging the right down bar or clicking the right arrow down will not reach the most bottom. To reach most bottom you need to click once inside the top box then press page down, or use mouse to select the text and drag down to most bottom.)

    Changing column width, wrap text does not increase the character limit in a cell. I use Excel 2019
    Can someone here teach how to copy all text from 1996 California Proposition 218 - Wikipedia into a single cell so in future I can read the text in the top box? Please refer to my post#8. You can see after copying and pasting all the text, the last character it shows is "expres", after that a lot of characters not copied into the cell. Thanks.

    Maybe it is already written somewhere in some of your answers, but I could not figure out how to do it. Can you write in step by step form, e.g. if I want to bold a text in Excel, I would write 1. click [home] in top menu>2. use mouse to select text>3. click [B] icon.
      My Computer


  2. Posts : 1,345
    Windows 10 Pro 64-bit
       #22

    "Can someone here teach how to copy all text from 1996 California Proposition 218 - Wikipedia into a single cell so in future I can read the text in the top box? Please refer to my post#8. You can see after copying and pasting all the text, the last character it shows is "expres", after that a lot of characters not copied into the cell. Thanks."
    --- I think sygnus21 could help you best on that.

    "Maybe it is already written somewhere in some of your answers, but I could not figure out how to do it. Can you write in step by step form, e.g. if I want to bold a text in Excel, I would write 1. click [home] in top menu>2. use mouse to select text>3. click [B] icon."
    --- Your way works but I select the word I want to bold and press ctrl+B.

    I copied/pasted "all text from 1996 California Proposition 218 - Wikipedia" into a txt document.
    Copy/pasted into a Word document. Closed up all paragraph spaces: naturally not the sentences.
    Results: Characters no spaces) 135,708. Characters (with spaces) 159,289.

    Excel 2021 cell limit-characters-information.jpg

    With the information I got, you should be able to accomplish what you want to do.
    --- However, you haven't let us know how many characters to have to work with.
    --- Do you know what that is?
    --- Is it less than "the limit of 167,336 recorded characters"

    Now I wish I would have gotten the count before closing up all paragraphs to no spacing but to see how much of a difference it would have made.
      My Computer


  3. Posts : 372
    Windows 10 Home: 21H1 (OS Build 19043.1586)
       #23

    Definitive statement of Excel single cell capacity limitations


    I have re-read and tuned into the OP's question, exhaustively tested Excel's single cell capacity, and my conclusion is that it is not possible to achieve what the OP wants. Here is all of the evidence below. (Note the counts below the B2 cell that I have included)

    Excel 2021 cell limit-b2-scc-count-final.png

    I used simple copy and paste into the B2 cell replicating the OP's preferred method and staying in line with his exact question.

    The image above shows the highlighted B2 cell as well as a slightly expanded "top box" (Formula bar) containing the contents of B2 which, as the OP points out, can only be viewed using the Page Down keyboard function.

    I took character counts from both Word and Excel using the formula
    Code:
    =LEN(B2)
    I hope this post is helpful.


    Christophe
    Last edited by CMArbres; 05 Dec 2021 at 07:47.
      My Computers


  4. Posts : 5,899
    Win 11 Pro (x64) 22H2
       #24

    comcom said:
    Can someone here teach how to copy all text from 1996 California Proposition 218 - Wikipedia into a single cell so in future I can read the text in the top box? Please refer to my post#8. You can see after copying and pasting all the text, the last character it shows is "expres", after that a lot of characters not copied into the cell. Thanks.

    Maybe it is already written somewhere in some of your answers, but I could not figure out how to do it. Can you write in step by step form, e.g. if I want to bold a text in Excel, I would write 1. click [home] in top menu>2. use mouse to select text>3. click [B] icon.
    Realize Excel is not designed to be a word document. Typically, a cell would hold a title or some short text far less then 255 characters. With that if you need far more than the cell limitation, you could either insert a Word document... Insert an object in your Excel spreadsheet. There's also the option to link to documents such as Word, PDF or website from within Excel

    At the end of the day, you're not going to overcome the cell limit, so I suggest you look for alternatives as suggested above.

    Good luck
      My Computers


  5. Posts : 323
    Windows 10 Home 64 bit x64 Version 22H2
    Thread Starter
       #25

    MeAndMyComputer said:
    "Can someone here teach how to copy all text from 1996 California Proposition 218 - Wikipedia into a single cell so in future I can read the text in the top box? Please refer to my post#8. You can see after copying and pasting all the text, the last character it shows is "expres", after that a lot of characters not copied into the cell. Thanks."
    --- I think sygnus21 could help you best on that.

    "Maybe it is already written somewhere in some of your answers, but I could not figure out how to do it. Can you write in step by step form, e.g. if I want to bold a text in Excel, I would write 1. click [home] in top menu>2. use mouse to select text>3. click [B] icon."
    --- Your way works but I select the word I want to bold and press ctrl+B.

    I copied/pasted "all text from 1996 California Proposition 218 - Wikipedia" into a txt document.
    Copy/pasted into a Word document. Closed up all paragraph spaces: naturally not the sentences.
    Results: Characters no spaces) 135,708. Characters (with spaces) 159,289.

    Excel 2021 cell limit-characters-information.jpg

    With the information I got, you should be able to accomplish what you want to do.
    --- However, you haven't let us know how many characters to have to work with.
    --- Do you know what that is?
    --- Is it less than "the limit of 167,336 recorded characters"

    Now I wish I would have gotten the count before closing up all paragraphs to no spacing but to see how much of a difference it would have made.
    I do not know how many characters. I just want to copy and paste all the text seen in an article, for example in this example I would like to copy and paste all text from the Wikipedia article in a single cell. I do copy and paste while I am doing research, sometimes I am researching multiple sites and would copy multiple urls into a single cell too (so in future I can refer to the sites again) but due to characters limit I would need 2 cells or more to completely input all the characters what I want, for example I would need to have a blank row below B2, after B2 reached character limit I would continue in B3. At the end of B2 I would write a note for my own reference "(continue in the cell below)".
      My Computer


  6. Posts : 1,345
    Windows 10 Pro 64-bit
       #26

    Is this what you are looking for?

    Excel 2021 cell limit-ok-top-portion.jpg

    Excel 2021 cell limit-ok-bottom-portion.jpg

    I formatted the cell into a WORD entry, I don't recall the exact wording.
    --- That means I will have review how I accomplished that but I'm in a hurry right now.
    --- If someone else knows how I most likely formatted the cell, please chime in.

    The full text I had copied into column A fit.
    Then I moved over to Column B so you can fit it in there just as well.
    I did not expand the cell. Just pasted the text I had copied and the cell adjusted itself.

    BTW, I agree with sygnus21 "Realize Excel is not designed to be a word document."

    I do not know how to post the OK Excel spreadsheet.
    --- I've got to go out won't be back until tomorrow evening. I have to wait & see if I can figure it out.
    Excel 2021 cell limit Attached Files
      My Computer


  7. Posts : 1,345
    Windows 10 Pro 64-bit
       #27

    Edited out everything.
    as sygnus21 said, it was utterly ridiculous with too many words, etc.

    I should have left the information in post #26 to be referred to

    @comcom, if your copied text is less than 167,336 recorded characters, it will fit.

    In my post #22
    Results: Characters no spaces) 135,708. Characters (with spaces) 159,289."
    Last edited by MeAndMyComputer; 08 Dec 2021 at 02:30.
      My Computer


  8. Posts : 5,899
    Win 11 Pro (x64) 22H2
       #28

    MeAndMyComputer said:
    This is the full content I pasted in the cell
    Sorry but it's utterly ridiculous to post an entire 24 thousand+ word document (consisting of 47 pages in a Word doc) in a post!!!

    Your post basically takes a minute just to scroll past it
      My Computers


  9. Posts : 1,345
    Windows 10 Pro 64-bit
       #29

    sygnus21 said:
    Sorry but it's utterly ridiculous to post an entire 24 thousand+ word document (consisting of 47 pages in a Word doc) in a post!!!

    Your post basically takes a minute just to scroll past it
    You are correct. I'll edit it out and leave a summary.
    Last edited by MeAndMyComputer; 08 Dec 2021 at 02:31.
      My Computer


  10. Posts : 31,459
    10 Home x64 (22H2) (10 Pro on 2nd pc)
       #30

    comcom said:
    Can someone here teach how to copy all text from 1996 California Proposition 218 - Wikipedia into a single cell so in future I can read the text in the top box? Please refer to my post#8. You can see after copying and pasting all the text, the last character it shows is "expres", after that a lot of characters not copied into the cell. Thanks.

    Maybe it is already written somewhere in some of your answers.....

    You got your answer in post #2. It is NOT possible to do what you want with a single cell, the maximum number a cell can contain is 32,767 characters. It is only possible if you merge enough cells before you paste, as explained in post #10.


    Worksheet and workbook specifications and limits

    Feature Maximum limit
    Total number of characters that a cell can contain 32,767 characters
    Microsoft | Excel specifications and limits
      My Computers


 

  Related Discussions
Our Sites
Site Links
About Us
Windows 10 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 10" and related materials are trademarks of Microsoft Corp.

© Designer Media Ltd
All times are GMT -5. The time now is 04:41.
Find Us




Windows 10 Forums