Standard charachter count?

[gtg689a]

Is there a standard amount of charachters per line in excel?

Right now I have an If statement that tests the rowheight, but I have found that there is a problem with this.

The macro puts each name in the same cell but skips ahead 10 charachters to go to the next line.

What I would like to do is make the if statement based on the number of charachters in the cell, and not it's height.


so right now it says:
if the row height is X, then offset(0,1)
I want it to say
if the charachters in the cell are X(the X here is the big question), then offset(0,1).

[DKenny]

but skips ahead 10 charachters to go to the next line.

Are you sure that your source data doesn't have trailing spaces?

if the charachters in the cell are X(the X here is the big question)

You could check the LEN of the text in teh cell.