Excel is only able to store 32767 characters in one cell. But I retrieve the more than 50000 characters.So, I couldn't able to store in the cell. So, I wish to store the value to a variable in Excel vba. Is it possible to store the value of the variable in excel vba? How to store the value in a variable? Or Is there any option to Increase the cell value more than 50000 Char in excel?
Thanks in advance,
How to store cell value in a variable excel vba OR Increase Cell Value in Excel
Excel is not meant to be used as a database (more for calculations than anything else) and I would suspect that you are importing data from some external source into Excel. The cell limit of 32,767 characters is by design and is "not negotiable". There are work-arounds but these could do more harm than good and would be difficult to use and the time spent on trying work-arounds would be better spent on setting up/using actual database applications such as Access.
Consider that Excel holds in excess of 17 billion cells and then consider there are 30,000plus characters per cell, then consider the size of your workbook.
You'll find Excel specifications and limits here:-