Take the 2-minute tour ×

I have a long excel formula that exceeds the 255 character limit that excel allows in a single cell. I get around this by adding "&" after every 255th character so that the next parts of the formula are concatenated to the previous.

 ="text...text"&"text..text"&ROWS(A$1:A1)&"text...text"&"text...text" and so on

I would like to add to a piece of code to my formula in order to do this automatically.

Many thanks in advance.

share|improve this question
This could be clearer. Can you provide a mroe detailed example? –  brettdj Nov 30 '12 at 0:50
255 char limit sounds odd, which version of Excel are you using ? –  Romain Nov 30 '12 at 14:23
I have a single cell full of text. Put simply, all i need is a formula that allows me to automatically insert characters into this cell at the position i specify, for example after every 255th character. I'm using the excel starter edition 2010. Thanks –  Raj Gundu Nov 30 '12 at 17:36
add comment

1 Answer

In Excel 2010 255 characters is the limitation on a column's width. The cell limit is 32,767 characters.

Conventional ways to address such limits include text wrapping and inserting text boxes. Merging cells is another solution but not recommended.

Since formulae are mentioned, the normal limit of what is readily visible in the formula bar of around 200 characters can be extended either by scrolling or expanding the formula bar (in both cases using arrows on the extreme right) or dragging its lower boundary.

In the formula bar Alt+Enter may be useful to insert line breaks so that repetitive elements of a complex formula are lined up for comparison.

share|improve this answer
add comment

Your Answer


