Dear all,

My name is Carlos, nice to e-meet you!

I have a special request and I was wondering if any of you have a workaround or a precise formula/macro to achieve it.

Basically I have an Excel file with several character limitations, so some cells can only have one line of text, other can have from two up to three lines. Most of the conditions are that the cell has to have 60 characters the most. So I was wondering if there is the possibility to show how many characters there are in a line and the results shown separated by a comma.

A visual example is the following:

Character Limit to Meet Text Number of Characters per Line within a Cell
60 characters * 2 lines This is an example, first line
This is the second line		 30,23

I hope any of you have a reply to this question.

Best regards,