How do I replace a text string with a line break?
Posted by Tom on April 11, 2001 6:15 PM
Here is my dilema in Excel 97: I am looking for a way to replace a string of text with a line break within a cell (i.e. the equivalent to Alt+Enter).
Is there such a way to do this? Perhaps there is an Ascii equivalent that I can use in the replace field?
I stumbled upon a macro that worked for most cells, but once it encountered a cell with too many characters it gives a "Run time error '1004' Formula is too long" message.
Any guidance would be greatly appreciated!!