Error: "The text string you entered is too long. Reduce the number of characters used or cancel this entry.

mattu1990

Board Regular
Joined
Mar 9, 2013
Messages
52
Hi Everyone,

I have a bit of a strange one here in Excel 2010. Basically I have a list of coordinates across from column B to column AWU and I need to concatenate them all into one cell with a space between each. In column AWV I am trying the following formula as an example.

<code>
=ConcatenateRange=(B4304:AWU4304)
</code>

The formula runs on this VBA (which adds a space between the coordinates in each cell.)

<code>
Function ConcatenateRange(rCells As Range)


'This function makes a concatenate range add a space between the contents of each cell
'in a selected range.


Dim vTemp As Variant
Application.Volatile


For Each vTemp In rCells
ConcatenateRange = ConcatenateRange & vTemp & " "
Next vTemp
End Function
</code>

the formula works fine and concatenates the contents. The problem however is when I then try copy and pasting the results somewhere else as "Paste Values"

I get the error as show in the title of this thread. The contents show in the cell but not in the formula bar. Every time that cell is then selected, the error shows.

The total cell contents does not exceed the 32,767 limit. It contains 25,000 or less.

Anyone know why this would happen?

Cheers,
 

Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type
In Excel 2010 I can copy and paste special values this formula without seeing the error you are getting:

=REPT("a ",16000)
 
Last edited:
Upvote 0
=REPT isn't working for me. Just throws back #VALUE

Anyone else have any ideas?

Maybe there is a maximum number of cells that Excel can concatenate at once?
 
Upvote 0
What formula with REPT returns #VALUE!? I just used it to demonstrate that a cell can hold 32,000 characters without producing the message you are seeing. That message usually relates to a chart's series formula.
 
Upvote 0
When I use REPT to refer to my coordinates it shows that. Here is the data I am trying to get in one cell.

<code>
-6.583756,58.362821 -6.566542,58.343451 -6.555246,58.333491 -6.546568,58.305899 -6.541128,58.273345 -6.545289,58.271025 -6.558347,58.262099 -6.566327,58.255992 -6.560005,58.25128 -6.558366,58.249343 -6.535274,58.229432 -6.471882,58.212015 -6.465356,58.211257 -6.436734,58.211853 -6.432206,58.211424 -6.405093,58.208039 -6.404979,58.207984 -6.403745,58.208548 -6.39689,58.208522 -6.397751,58.208053 -6.396961,58.207005 -6.393062,58.201829 -6.395418,58.200218 -6.395083,58.200049 -6.389241,58.197103 -6.387056,58.194906 -6.382239,58.190059 -6.380535,58.192816 -6.376563,58.193762 -6.374805,58.191933 -6.371276,58.192324 -6.373325,58.188207 -6.38837,58.180404 -6.380755,58.179407 -6.378593,58.177053 -6.380937,58.175353 -6.375632,58.169599 -6.374507,58.164601 -6.373096,58.163693 -6.369332,58.161271 -6.36783,58.154577 -6.374554,58.149759 -6.389951,58.1477 -6.408571,58.142829 -6.412894,58.143399 -6.422697,58.148366 -6.423277,58.146187 -6.417218,58.143968 -6.419072,58.142777 -6.422101,58.140831 -6.418076,58.140889 -6.417687,58.140894 -6.418193,58.140589 -6.420218,58.139367 -6.418967,58.138596 -6.418008,58.138005 -6.401944,58.142879 -6.399851,58.143133 -6.389543,58.144386 -6.383711,58.144115 -6.369527,58.143455 -6.367572,58.137227 -6.370908,58.135313 -6.371316,58.131702 -6.37846,58.131726 -6.386176,58.129481 -6.396298,58.134349 -6.401071,58.13458 -6.405776,58.131233 -6.414091,58.132474 -6.41646,58.131408 -6.420372,58.129648 -6.434238,58.133123 -6.446428,58.132698 -6.447079,58.133045 -6.450072,58.134639 -6.460094,58.135907 -6.461552,58.137255 -6.463749,58.139287 -6.468533,58.140016 -6.479567,58.141695 -6.494964,58.144036 -6.49038,58.141409 -6.49099,58.139499 -6.479527,58.137647 -6.469785,58.136072 -6.468594,58.135879 -6.464759,58.132416 -6.468157,58.131037 -6.468519,58.128506 -6.465601,58.129234 -6.459286,58.130809 -6.453238,58.127891 -6.446077,58.124435 -6.451421,58.129412 -6.451849,58.12981 -6.449522,58.1316 -6.449042,58.131403 -6.44307,58.128947 -6.434108,58.12935 -6.435589,58.127589 -6.438285,58.128754 -6.43646,58.126389 -6.428717,58.127019 -6.431051,58.121181 -6.438138,58.120754 -6.444144,58.118476 -6.445888,58.116592 -6.448188,58.114107 -6.451063,58.115356 -6.46004,58.105597 -6.46444,58.104094 -6.467146,58.105348 -6.468793,58.103581 -6.476011,58.104227 -6.481606,58.10253 -6.482721,58.102191 -6.484807,58.103917 -6.49207,58.099523 -6.497337,58.102215 -6.499343,58.100615 -6.507181,58.102137 -6.508743,58.100761 -6.510164,58.099508 -6.512073,58.097826 -6.514539,58.098325 -6.518873,58.099203 -6.515638,58.100488 -6.52618,58.099213 -6.539667,58.100707 -6.540311,58.100779 -6.539991,58.099774 -6.539745,58.099 -6.531705,58.098567 -6.529324,58.097212 -6.530607,58.095278 -6.533331,58.094718 -6.541203,58.093101 -6.553796,58.09328 -6.556594,58.093016 -6.579036,58.090891 -6.597433,58.089146 -6.598394,58.089055 -6.610112,58.087942 -6.6241,58.086612 -6.628808,58.086164 -6.631158,58.082031 -6.627685,58.081377 -6.627155,58.081277 -6.625524,58.079177 -6.622032,58.079754 -6.618509,58.08402 -6.610388,58.085574 -6.606705,58.079411 -6.603302,58.085381 -6.602412,58.086943 -6.596885,58.087357 -6.579196,58.08868 -6.574182,58.087195 -6.571075,58.086274 -6.567389,58.08285 -6.565099,58.080722 -6.561408,58.088483 -6.561352,58.088602 -6.561286,58.088598 -6.535693,58.087181 -6.527433,58.089004 -6.526128,58.088958 -6.518561,58.08869 -6.51136,58.093533 -6.507369,58.094214 -6.499398,58.092967 -6.495999,58.093469 -6.486556,58.09486 -6.482035,58.09403 -6.479702,58.091684 -6.476601,58.092692 -6.474629,58.090513 -6.473511,58.093052 -6.471853,58.096817 -6.455674,58.095136 -6.451109,58.096293 -6.449087,58.096806 -6.441942,58.093997 -6.434243,58.093546 -6.432487,58.091719 -6.430305,58.094221 -6.427878,58.097006 -6.42066,58.097707 -6.41888,58.098896 -6.417679,58.099699 -6.420397,58.099387 -6.428901,58.09841 -6.429665,58.100452 -6.433095,58.099343 -6.436306,58.10058 -6.43119,58.102878 -6.422627,58.106723 -6.418838,58.106315 -6.421504,58.104514 -6.4182,58.103909 -6.415366,58.105716 -6.416827,58.107914 -6.406386,58.111424 -6.40498,58.109674 -6.400371,58.112262 -6.396548,58.10331 -6.393407,58.109534 -6.386967,58.105529 -6.395713,58.099291 -6.403121,58.104252 -6.403579,58.101088 -6.398357,58.097311 -6.395484,58.096061 -6.388814,58.09845 -6.388743,58.098365 -6.385623,58.094602 -6.385391,58.092722 -6.393793,58.091982 -6.396337,58.093333 -6.398911,58.092165 -6.395943,58.084622 -6.389378,58.086468 -6.382608,58.092188 -6.379133,58.092937 -6.37831,58.082082 -6.380289,58.080215 -6.377746,58.078864 -6.372865,58.079211 -6.37197,58.078668 -6.368096,58.076317 -6.38048,58.069325 -6.379742,58.067462 -6.366814,58.065838 -6.366134,58.057497 -6.372662,58.055383 -6.373786,58.049319 -6.387818,58.048386 -6.401887,58.047449 -6.439195,58.050073 -6.440393,58.050157 -6.439368,58.049945 -6.420717,58.046076 -6.412091,58.046286 -6.402811,58.04256 -6.393577,58.043329 -6.391859,58.04177 -6.378629,58.042771 -6.376566,58.042927 -6.360595,58.041317 -6.358126,58.039153 -6.358811,58.030855 -6.359013,58.030775 -6.364311,58.028688 -6.364403,58.028277 -6.366289,58.019895 -6.377292,58.016998 -6.382203,58.011432 -6.390066,58.007833 -6.386836,58.000839 -6.393889,58.000325 -6.399844,58.001918 -6.409416,58.01085 -6.416827,58.011852 -6.418904,58.013579 -6.425355,58.010926 -6.431989,58.012493 -6.435346,58.016334 -6.438722,58.016216 -6.438255,58.012454 -6.444703,58.01115 -6.444289,58.009185 -6.451073,58.007868 -6.451529,58.008446 -6.460532,58.019859 -6.4685,58.017151 -6.466287,58.013001 -6.469585,58.010906 -6.484939,58.011714 -6.49466,58.015197 -6.500024,58.017117 -6.49963,58.015332 -6.494367,58.012648 -6.490394,58.010622 -6.493989,58.009356 -6.500618,58.007022 -6.517795,58.01019 -6.525054,58.015329 -6.52507,58.007412 -6.527948,58.00605 -6.550354,58.007678 -6.58295,58.004167 -6.566472,58.002512 -6.550787,58.004424 -6.541933,58.001413 -6.51898,57.999443 -6.511885,58.000955 -6.504463,57.999869 -6.498964,58.001953 -6.493149,58.002047 -6.47563,58.002328 -6.456745,57.994897 -6.455004,57.993253 -6.452522,57.990907 -6.454774,57.98723 -6.456492,57.986745 -6.458047,57.986306 -6.456807,57.985366 -6.450567,57.980632 -6.450294,57.974345 -6.454254,57.970788 -6.449449,57.967538 -6.451047,57.965414 -6.462185,57.961065 -6.462349,57.961106 -6.465329,57.961854 -6.466993,57.960266 -6.468423,57.941866 -6.475207,57.937939 -6.480481,57.940901 -6.482076,57.938776 -6.48559,57.938472 -6.485867,57.938524 -6.501003,57.941344 -6.506727,57.933045 -6.515753,57.928777 -6.515984,57.928668 -6.519677,57.929796 -6.520354,57.930821 -6.523856,57.936124 -6.526033,57.934607 -6.527989,57.938045 -6.525285,57.939401 -6.529596,57.940057 -6.533562,57.943333 -6.535716,57.941637 -6.538793,57.943236 -6.546202,57.958982 -6.54833,57.954408 -6.544411,57.946183 -6.546492,57.942425 -6.547715,57.940218 -6.53814,57.931385 -6.536202,57.924079 -6.539383,57.918478 -6.547112,57.918111 -6.550154,57.919441 -6.550421,57.917542 -6.557206,57.916399 -6.562487,57.920707 -6.561581,57.916242 -6.565229,57.91701 -6.569703,57.921617 -6.56628,57.92129 -6.565858,57.923284 -6.572224,57.925484 -6.573314,57.920767 -6.569039,57.915074 -6.570759,57.911324 -6.577472,57.9136 -6.577278,57.917385 -6.583735,57.914993 -6.589709,57.922064 -6.596234,57.924166 -6.593522,57.925434 -6.594627,57.927463 -6.60108,57.931637 -6.602205,57.936454 -6.609247,57.941235 -6.611582,57.944929 -6.608614,57.950794 -6.611952,57.951752 -6.613888,57.949703 -6.618412,57.949358 -6.640296,57.961877 -6.644726,57.96441 -6.642958,57.960752 -6.640796,57.956278 -6.625484,57.942533 -6.622644,57.93625 -6.626383,57.936384 -6.613876,57.928563 -6.612003,57.921884 -6.606082,57.919221 -6.612479,57.91638 -6.615413,57.918162 -6.618124,57.916894 -6.623019,57.918155 -6.632134,57.928527 -6.631319,57.923519 -6.634052,57.92243 -6.644241,57.925386 -6.648031,57.919399 -6.65323,57.920378 -6.673715,57.936178 -6.678719,57.944719 -6.679496,57.945301 -6.687533,57.951321 -6.69137,57.958331 -6.692648,57.960668 -6.697682,57.96291 -6.698654,57.959996 -6.702484,57.962103 -6.70248,57.967231 -6.708283,57.970164 -6.710618,57.979686 -6.711934,57.985052 -6.70453,57.995449 -6.704498,57.995494 -6.705918,57.99985 -6.712826,58.005981 -6.71058,58.01596 -6.694423,58.02728 -6.691329,58.029447 -6.688867,58.033946 -6.681041,58.037653 -6.672216,58.037618 -6.665315,58.04192 -6.666105,58.049267 -6.664558,58.053013 -6.660499,58.054421 -6.640928,58.055011 -6.632439,58.055267 -6.623572,58.051002 -6.628191,58.048675 -6.621151,58.048031 -6.611738,58.051342 -6.589321,58.052513 -6.5924,58.054021 -6.604741,58.053665 -6.611448,58.05567 -6.62245,58.055451 -6.635187,58.058135 -6.640298,58.058054 -6.678713,58.05744 -6.695815,58.058429 -6.69001,58.055584 -6.677622,58.055591 -6.670428,58.053786 -6.670871,58.045494 -6.702267,58.031381 -6.702682,58.030653 -6.704885,58.026786 -6.723103,58.014505 -6.749934,58.007071 -6.772815,58.059248 -6.779495,58.062111 -6.893388,58.02428 -6.916996,58.028278 -6.965166,58.041514 -6.957586,58.045246 -6.938453,58.04923 -6.917068,58.051679 -6.909501,58.049723 -6.908989,58.052172 -6.915795,58.053528 -6.945823,58.049753 -6.97765,58.048181 -6.980544,58.048037 -7.014507,58.040942 -7.025415,58.036462 -7.031061,58.035437 -7.036829,58.03439 -7.041122,58.03476 -7.043314,58.038272 -7.048322,58.035284 -7.053151,58.04184 -7.0602,58.04129 -7.063672,58.043041 -7.060766,58.046486 -7.052092,58.047551 -7.047134,58.050898 -7.028986,58.050988 -7.021343,58.053359 -7.025847,58.056421 -7.034039,58.056726 -7.054641,58.053569 -7.058376,58.05477 -7.055884,58.058769 -7.053258,58.062982 -7.040404,58.065742 -7.039188,58.06795 -7.03609,58.066453 -7.03044,58.069736 -7.023123,58.070835 -7.028545,58.07557 -7.029222,58.081572 -7.032938,58.081425 -7.03509,58.076211 -7.041065,58.072824 -7.06897,58.067215 -7.062797,58.064402 -7.062336,58.062351 -7.065248,58.061335 -7.069089,58.062081 -7.072001,58.061065 -7.079521,58.064994 -7.082162,58.063269 -7.083936,58.064998 -7.087313,58.064862 -7.0861,58.067071 -7.080735,58.067555 -7.100533,58.070631 -7.099957,58.072544 -7.102928,58.074315 -7.099115,58.077347 -7.103937,58.082553 -7.103132,58.094733 -7.106885,58.096022 -7.106036,58.098396 -7.111646,58.10078 -7.111225,58.110875 -7.11482,58.1146 -7.122009,58.116111 -7.135473,58.123396 -7.132935,58.124669 -7.133676,58.126624 -7.134582,58.129012 -7.127244,58.139476 -7.123678,58.13953 -7.118529,58.136857 -7.109889,58.144224 -7.113723,58.147219 -7.11316,58.149222 -7.116858,58.149847 -7.11421,58.151789 -7.107965,58.14979 -7.104643,58.151543 -7.101936,58.153517 -7.10079,58.154352 -7.101938,58.156421 -7.09606,58.159356 -7.097527,58.161277 -7.089888,58.165002 -7.09802,58.168276 -7.103442,58.172828 -7.100769,58.174375 -7.107328,58.177351 -7.104959,58.183385 -7.096597,58.188039 -7.093799,58.186352 -7.083916,58.188726 -7.081726,58.184135 -7.071532,58.183632 -7.064569,58.183289 -7.058101,58.180936 -7.054268,58.181538 -7.054765,58.185028 -7.050585,58.184384 -7.049343,58.181644 -7.052391,58.177923 -7.048928,58.177521 -7.046065,58.172955 -7.039307,58.179342 -7.038526,58.181508 -7.037595,58.184089 -7.021904,58.187053 -7.021334,58.18716 -7.021073,58.18672 -7.019096,58.18338 -7.015399,58.182535 -7.012104,58.183131 -7.007758,58.183916 -7.013194,58.186221 -7.014987,58.184441 -7.018001,58.192511 -7.020628,58.190607 -7.021807,58.191631 -7.024946,58.194359 -7.02568,58.194997 -7.028943,58.193969 -7.033096,58.201633 -7.036517,58.196909 -7.036005,58.1909 -7.039564,58.190759 -7.0415,58.188793 -7.045575,58.189891 -7.047464,58.193596 -7.064996,58.197039 -7.061645,58.197442 -7.063236,58.201428 -7.060459,58.205858 -7.051242,58.209373 -7.054802,58.209231 -7.058521,58.212593 -7.055822,58.214477 -7.050456,58.218222 -7.050372,58.220025 -7.054111,58.221137 -7.052336,58.225436 -7.047944,58.22813 -7.050311,58.230375 -7.048907,58.232501 -7.039916,58.232857 -7.035683,58.241482 -7.024788,58.244071 -7.027036,58.233455 -7.023648,58.232419 -7.016029,58.235239 -7.006584,58.2348 -7.005156,58.233147 -7.002983,58.234672 -6.999112,58.233834 -6.99444,58.228528 -6.994324,58.228493 -6.987849,58.226537 -6.987428,58.224754 -6.979739,58.221006 -6.970367,58.219842 -6.966145,58.221356 -6.966483,58.222893 -6.967086,58.225638 -6.964962,58.227521 -6.969258,58.231402 -6.96222,58.232306 -6.961961,58.234116 -6.957682,58.234012 -6.954453,58.232878 -6.949836,58.22424 -6.948707,58.223752 -6.946206,58.222672 -6.942863,58.223161 -6.938354,58.219071 -6.928807,58.216994 -6.924821,58.217048 -6.919106,58.217126 -6.916116,58.218438 -6.908383,58.213067 -6.909297,58.211053 -6.912809,58.210558 -6.90956,58.205554 -6.912666,58.203365 -6.931302,58.202555 -6.934481,58.202859 -6.942702,58.203643 -6.945748,58.202265 -6.944928,58.200047 -6.948855,58.201436 -6.956702,58.204211 -6.958912,58.204992 -6.962472,58.204854 -6.96393,58.203087 -6.960817,58.202387 -6.95302,58.200633 -6.947205,58.195136 -6.946346,58.194324 -6.937454,58.19287 -6.935038,58.187745 -6.924134,58.188976 -6.918263,58.186298 -6.917588,58.18599 -6.910098,58.187269 -6.908834,58.185518 -6.905445,58.185649 -6.896215,58.187893 -6.893137,58.186572 -6.888225,58.173373 -6.88746,58.171315 -6.888844,58.162805 -6.891932,58.159267 -6.891041,58.156656 -6.889082,58.150919 -6.883374,58.143587 -6.878134,58.136854 -6.877758,58.134717 -6.876594,58.128096 -6.865702,58.119484 -6.860189,58.115123 -6.860251,58.118014 -6.862345,58.120639 -6.867843,58.127531 -6.86588,58.131835 -6.866786,58.132844 -6.879097,58.14655 -6.880333,58.147926 -6.880747,58.155968 -6.881152,58.163819 -6.883847,58.162367 -6.885256,58.165192 -6.882283,58.172054 -6.87127,58.171216 -6.869556,58.173621 -6.873891,58.176935 -6.877737,58.179875 -6.876873,58.189715 -6.872887,58.187978 -6.873958,58.184609 -6.860491,58.180805 -6.861285,58.185363 -6.86056,58.185936 -6.859133,58.187064 -6.860002,58.188364 -6.863417,58.193469 -6.860303,58.191878 -6.858671,58.19365 -6.855195,58.193153 -6.847818,58.200271 -6.847943,58.198732 -6.848009,58.197925 -6.843975,58.197089 -6.838057,58.199923 -6.840505,58.201629 -6.829449,58.204298 -6.821962,58.200623 -6.818976,58.200902 -6.813885,58.201378 -6.806957,58.1993 -6.803663,58.200145 -6.797575,58.199229 -6.792183,58.198418 -6.787595,58.194722 -6.783829,58.194593 -6.782511,58.192394 -6.785769,58.191282 -6.782138,58.188359 -6.779338,58.192872 -6.770564,58.190666 -6.759415,58.187861 -6.756504,58.191568 -6.75303,58.191068 -6.750485,58.192422 -6.741046,58.180855 -6.734601,58.172952 -6.733444,58.170656 -6.736737,58.169814 -6.735809,58.167959 -6.728644,58.169125 -6.730969,58.173807 -6.727628,58.174291 -6.718585,58.170308 -6.715942,58.172205 -6.723636,58.178847 -6.724257,58.183519 -6.72429,58.183771 -6.706764,58.18441 -6.714596,58.187728 -6.721025,58.1874 -6.725277,58.190874 -6.734406,58.198329 -6.73432,58.192574 -6.73614,58.192177 -6.737797,58.191815 -6.738167,58.192827 -6.739942,58.197673 -6.744827,58.194959 -6.745097,58.194809 -6.76262,58.200336 -6.76269,58.200676 -6.763083,58.202596 -6.763114,58.202747 -6.759505,58.202522 -6.757857,58.20614 -6.75738,58.207188 -6.756213,58.209752 -6.748865,58.210105 -6.747914,58.210151 -6.744568,58.206789 -6.742992,58.205206 -6.736051,58.205555 -6.737296,58.207144 -6.737695,58.207653 -6.738397,58.20709 -6.739696,58.206049 -6.740735,58.206976 -6.741438,58.207603 -6.742958,58.211325 -6.740036,58.212424 -6.742163,58.212401 -6.74344,58.212387 -6.747101,58.214966 -6.748898,58.216232 -6.756398,58.216222 -6.756902,58.21651 -6.76083,58.218756 -6.763949,58.225476 -6.767966,58.229805 -6.77452,58.236866 -6.778425,58.23546 -6.778147,58.233402 -6.787128,58.238013 -6.788353,58.235718 -6.790291,58.239963 -6.799626,58.24591 -6.799372,58.247809 -6.790968,58.247495 -6.791392,58.249368 -6.798523,58.2491 -6.807982,58.252162 -6.808095,58.253108 -6.809173,58.262194 -6.812352,58.262973 -6.814125,58.267225 -6.818834,58.270466 -6.811482,58.272903 -6.804407,58.27236 -6.801193,58.275642 -6.800657,58.276189 -6.794844,58.275842 -6.790499,58.275582 -6.789876,58.277829 -6.789466,58.279309 -6.786221,58.279291 -6.77904,58.27925 -6.778163,58.279628 -6.771328,58.282573 -6.770808,58.282797 -6.771127,58.282768 -6.784241,58.281571 -6.787511,58.281272 -6.792306,58.278843 -6.803728,58.279942 -6.819433,58.27863 -6.826183,58.280534 -6.827774,58.282184 -6.815991,58.289736 -6.808258,58.289398 -6.805109,58.291898 -6.804094,58.292704 -6.80492,58.296271 -6.80186,58.297646 -6.798277,58.296431 -6.796614,58.298023 -6.806245,58.303509 -6.802735,58.304091 -6.798909,58.307384 -6.789617,58.304404 -6.786579,58.308476 -6.779351,58.308117 -6.776289,58.309491 -6.772718,58.309625 -6.77017,58.305942 -6.768907,58.306442 -6.764653,58.308127 -6.7575,58.305785 -6.753611,58.307369 -6.753267,58.313619 -6.753263,58.31368 -6.746191,58.314483 -6.743921,58.312858 -6.737151,58.314638 -6.742821,58.317397 -6.741007,58.319173 -6.731854,58.321042 -6.727411,58.325989 -6.725752,58.327835 -6.714421,58.328794 -6.71019,58.334258 -6.704262,58.337265 -6.699701,58.337703 -6.696081,58.332348 -6.694852,58.332167 -6.691197,58.331628 -6.688141,58.33309 -6.689574,58.337445 -6.688238,58.337778 -6.672185,58.341771 -6.669698,58.343661 -6.671423,58.347646 -6.666352,58.35071 -6.661013,58.351206 -6.655195,58.351747 -6.649916,58.354548 -6.643575,58.344074 -6.640076,58.343481 -6.634909,58.348437 -6.631448,58.347875 -6.622672,58.346451 -6.617498,58.347448 -6.616753,58.34798 -6.613116,58.350575 -6.601984,58.353135 -6.594918,58.359326 -6.586876,58.359345 -6.583756,58.362821 -7.645448,58.281814 -7.650406,58.279685 -7.64938,58.281819 -7.645448,58.281814 -7.590114,58.285954 -7.596401,58.288315 -7.585452,58.289119 -7.590114,58.285954 -7.584857,58.282322 -7.58869,58.282784 -7.585719,58.284535 -7.578208,58.284594 -7.584857,58.282322 -7.133999,58.083682 -7.137377,58.083545 -7.13293,58.086874 -7.124055,58.086602 -7.118786,58.083035 -7.117378,58.077963 -7.119347,58.073924 -7.13549,58.075162 -7.130093,58.08015 -7.131364,58.081898 -7.135443,58.081914 -7.133999,58.083682 -7.125457,58.105803 -7.129941,58.106252 -7.127586,58.107607 -7.125457,58.105803 -7.111837,58.17672 -7.115314,58.17721 -7.110947,58.178826 -7.111837,58.17672 -6.942479,58.230194 -6.951685,58.237485 -6.951174,58.239934 -6.941561,58.237068 -6.937987,58.240805 -6.933441,58.236632 -6.933096,58.236316 -6.931567,58.228997 -6.938969,58.228261 -6.941628,58.229726 -6.942479,58.230194 -6.945723,58.241225 -6.948676,58.24282 -6.945174,58.243406 -6.941555,58.241927 -6.945723,58.241225 -6.915263,58.284871 -6.923415,58.283297 -6.918919,58.28536 -6.915263,58.284871 -6.918193,58.227265 -6.922008,58.230177 -6.917423,58.229094 -6.915271,58.230797 -6.911791,58.230301 -6.910415,58.224056 -6.916612,58.225706 -6.919976,58.224137 -6.921606,58.226053 -6.918193,58.227265 -6.913441,58.276663 -6.913896,58.278715 -6.910018,58.276615 -6.913441,58.276663 -6.903873,58.266775 -6.910691,58.266692 -6.91009,58.268515 -6.903873,58.266775 -6.891935,58.205063 -6.895225,58.207905 -6.895106,58.218167 -6.893836,58.217605 -6.888932,58.215435 -6.887107,58.212086 -6.883244,58.212504 -6.883192,58.21247 -6.877627,58.20885 -6.87858,58.207104 -6.886177,58.204351 -6.887185,58.203985 -6.891935,58.205063 -6.891198,58.254126 -6.891884,58.256619 -6.888284,58.257746 -6.888644,58.258165 -6.889707,58.259401 -6.883527,58.256669 -6.879479,58.258263 -6.855593,58.257106 -6.85297,58.255406 -6.849721,58.25661 -6.843385,58.252712 -6.84226,58.244477 -6.844428,58.242866 -6.84422,58.242549 -6.838612,58.234 -6.834556,58.239282 -6.829192,58.232468 -6.816403,58.231242 -6.821908,58.235352 -6.821182,58.237539 -6.817545,58.237137 -6.811568,58.234574 -6.812658,58.232553 -6.810273,58.231385 -6.803245,58.227941 -6.79987,58.226288 -6.796018,58.219235 -6.795084,58.22116 -6.791982,58.219657 -6.791061,58.221671 -6.787207,58.222176 -6.782643,58.21362 -6.785927,58.212687 -6.786656,58.207982 -6.782183,58.204493 -6.781704,58.204119 -6.782207,58.201898 -6.782239,58.20176 -6.783114,58.201811 -6.795464,58.202523 -6.801338,58.20689 -6.809888,58.207812 -6.809986,58.207823 -6.822268,58.206639 -6.82451,58.208084 -6.826943,58.205922 -6.827125,58.205908 -6.83639,58.205204 -6.840162,58.205419 -6.865765,58.206875 -6.871147,58.214228 -6.874158,58.21834 -6.862791,58.217515 -6.863764,58.219637 -6.860251,58.220131 -6.859008,58.21604 -6.854421,58.227371 -6.857134,58.226008 -6.856318,58.223789 -6.860537,58.226076 -6.864113,58.232129 -6.864287,58.233399 -6.864493,58.234904 -6.861003,58.235577 -6.861285,58.237635 -6.864862,58.237589 -6.870336,58.241429 -6.870656,58.237548 -6.867145,58.232748 -6.861628,58.225206 -6.863261,58.223435 -6.864938,58.22571 -6.87481,58.229291 -6.875852,58.230764 -6.87735,58.232883 -6.873918,58.231205 -6.87223,58.23038 -6.871925,58.231659 -6.871798,58.232196 -6.874621,58.237846 -6.879617,58.240804 -6.882177,58.239446 -6.88572,58.24039 -6.887519,58.242301 -6.883988,58.246395 -6.891198,58.254126 -6.877129,58.259793 -6.885993,58.268361 -6.884723,58.270299 -6.86098,58.265268 -6.85913,58.26174 -6.877129,58.259793 -6.867419,58.269881 -6.870841,58.26993 -6.870181,58.273824 -6.867419,58.269881 -7.094665,58.064028 -7.094685,58.066547 -7.091636,58.065409 -7.094665,58.064028 -6.93158,58.192287 -6.934263,58.194433 -6.92631,58.197048 -6.924648,58.197594 -6.923972,58.196485 -6.920898,58.191441 -6.93158,58.192287 -6.894764,58.193438 -6.903399,58.194275 -6.90339,58.194439 -6.903157,58.198693 -6.898812,58.19931 -6.895708,58.19781 -6.895359,58.196194 -6.894764,58.193438 -6.884702,58.193374 -6.885796,58.195131 -6.8813,58.193414 -6.884702,58.193374 -6.881792,58.174972 -6.88498,58.176809 -6.884819,58.180593 -6.881366,58.179016 -6.881459,58.175055 -6.881466,58.174784 -6.881792,58.174972 -6.862896,58.185931 -6.867684,58.189797 -6.867632,58.1899 -6.866743,58.191632 -6.862161,58.188028 -6.862415,58.187303 -6.862896,58.185931 -6.791606,58.22318 -6.795095,58.227547 -6.788212,58.223308 -6.791606,58.22318 -6.768372,58.195324 -6.777444,58.200321 -6.776354,58.202253 -6.773866,58.206662 -6.765682,58.20283 -6.765317,58.201917 -6.765133,58.201458 -6.762602,58.195119 -6.766587,58.19434 -6.768372,58.195324 -6.736524,58.186105 -6.740155,58.18651 -6.739509,58.189323 -6.732259,58.190934 -6.731732,58.191051 -6.731944,58.190833 -6.736524,58.186105 -6.768107,58.212006 -6.774818,58.212474 -6.774293,58.217442 -6.770319,58.217051 -6.768107,58.212006 -6.737965,58.000007 -6.738534,58.004304 -6.730022,58.00786 -6.722036,58.007708 -6.713027,57.998506 -6.712811,57.996306 -6.712524,57.993397 -6.716181,57.990293 -6.716596,57.988298 -6.721692,57.987119 -6.725698,57.987959 -6.736322,57.998395 -6.737913,57.999956 -6.737965,58.000007 -6.728975,58.178019 -6.730832,58.181729 -6.728015,58.179764 -6.728975,58.178019 -6.523123,58.096002 -6.525704,58.096802 -6.518624,58.097233 -6.518644,58.097214 -6.520753,58.095269 -6.523123,58.096002 -6.475651,58.100012 -6.478515,58.10117 -6.473283,58.101444 -6.475651,58.100012 -6.45138,58.101045 -6.451879,58.101475 -6.451422,58.101773 -6.448039,58.103972 -6.445592,58.105563 -6.443003,58.106698 -6.435119,58.110156 -6.431895,58.108829 -6.430909,58.104996 -6.433052,58.103481 -6.43372,58.103009 -6.441393,58.100319 -6.445116,58.099013 -6.449975,58.099833 -6.45138,58.101045 -6.458616,58.012641 -6.463753,58.017138 -6.460603,58.016349 -6.458616,58.012641 -6.439279,57.997487 -6.450271,58.00142 -6.443236,58.006164 -6.438177,58.004991 -6.421665,58.005747 -6.413504,57.998655 -6.42094,57.997138 -6.431087,58.001101 -6.431136,57.998761 -6.43641,57.998937 -6.439279,57.997487 -6.369488,57.898901 -6.381224,57.903713 -6.368876,57.903599 -6.359606,57.905177 -6.352322,57.903628 -6.356241,57.902505 -6.357809,57.897324 -6.349198,57.894561 -6.347913,57.88813 -6.353176,57.881383 -6.358161,57.893264 -6.369488,57.898901 -6.324303,57.89964 -6.341532,57.903819 -6.339023,57.908222 -6.335711,57.908785 -6.333749,57.903725 -6.324303,57.89964 -6.414158,58.122038 -6.41713,58.125443 -6.412605,58.125382 -6.409638,58.125343 -6.411643,58.123877 -6.414158,58.122038 -6.380844,58.101179 -6.388103,58.102342 -6.379666,58.102812 -6.379748,58.10157 -6.379785,58.10101 -6.380844,58.101179 -6.378977,58.117947 -6.382133,58.118737 -6.382097,58.118822 -6.381338,58.120564 -6.376834,58.121258 -6.375249,58.119424 -6.377262,58.118626 -6.378977,58.117947 -6.378015,58.093515 -6.381331,58.096999 -6.373604,58.097714 -6.371575,58.090858 -6.378015,58.093515
</code>

According to Word count on MS Word, with spaces that adds up to 24,106. when I paste that all into an Excel cell, the error pops up.

Even though the error pops up it still puts it in the cell though. You just can't edit it.

NOTE: While writing this, I just tried as a test by taking off the first "minus" and then retrying, and it works fine!

I'm guessing Excel must be taking the first minus and using it as the start of a long sum? or maybe some specific rule for cells that start with a minus?

The question now is if this can be overridden. I've tried formatting the cells as Text instead of General, but that doesn't seem to work.
 
Upvote 0
I wasn't suggesting that you use REPT. That's just a quick way of entering long text. But I see what you mean about the leading minus sign. Sorry, I don't know a solution to that.
 
Upvote 0
OK thanks for your help Andrew.

I personally think Excel is using the minus as a start of a sum, and seeing as the maximum characters in a formula is 8192 I believe, it's causing the error to occur by being 3 times that amount.

Does anyone else know of a way to make an Excel cell ignore data that is identical to the format of a formula.

If for example you could make a cell display the text =SUM(A1:B1) and not actually use that text as a formula (just display it as text instead) I think that would solve my problem.

Thanks,
 
Upvote 0
I tried setting the format as Text and then pasting the data into the cell. Still get the error and the format is re-set to General. I then reset it to text and still get the error.
 
Upvote 0
I was telling you how to show the formula =SUM(A1:B1) in a cell rather than its result. I didn't say it would overcome your problem with the leading minus.
 
Upvote 0

Forum statistics

Threads
1,213,521
Messages
6,114,109
Members
448,548
Latest member
harryls

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top