Re: Counting Characters Per Line

Assuming you want the lengths of each line and each line is delimited by a LineFeed character, then the following entered in B1 and copied across columns (ie to F1) will give the lengths of the lines of the text contained in cell A1. Note that a LineFeed character ( that produces the new line) counts as 1 character):

=LEN(MID($A1,SUMPRODUCT(N(OFFSET($A1,0,COLUMN($A1:A1)-COLUMN($A$1))))+1,FIND(CHAR(10),$A1&CHAR(10),SUMPRODUCT(N(OFFSET($A1,0,COLUMN($A1:A1)-COLUMN($A$1))))+1)-SUMPRODUCT(N(OFFSET($A1,0,COLUMN($A1:A1)-COLUMN($A$1))))))

Richard