mdmackillop
03-23-2005, 01:02 PM
Is there a method of calculationg the length of a string of text in relation to a cell?
My workbook setup does not allow me to autofit rows, as it would upset printer output. I would like then, having typed in a string of text, that the length is split into suitable lengths, additional rows inserted to suit, and the text written in the appropriate cells.
I've done this before based on a set number of characters, looking for the previous space and so on, which works tolerably well, but is not very flexible. Any suggestions for a better approach?
My workbook setup does not allow me to autofit rows, as it would upset printer output. I would like then, having typed in a string of text, that the length is split into suitable lengths, additional rows inserted to suit, and the text written in the appropriate cells.
I've done this before based on a set number of characters, looking for the previous space and so on, which works tolerably well, but is not very flexible. Any suggestions for a better approach?