How do you count characters in a Cell?

[davesaint]

My boss wants me to go through a 5 thousand line report and find all the cells that contain over 50 characters. Have any I deal what I need to do?

 

[SkipVought]

Hi
[tt]
=LEN(A1)
[/tt]

Skip,
[sub]
[red]Be Advised![/red]
The band of elderly oriental musicians, known as Ground Cover, is, in reality...
Asian Jasmine![/sub]

 

[AnotherHiggins]

=len(a1)


[tt]_____
[blue]-John[/blue][/tt]

Help us help you. Please read FAQ181-2886 before posting.

 

[AnotherHiggins]

grr. 1 second behind.

[tt]_____
[blue]-John[/blue][/tt]

Help us help you. Please read FAQ181-2886 before posting.

 

[SkipVought]

Slow today, John?

Skip,
[sub]
[red]Be Advised![/red]
The band of elderly oriental musicians, known as Ground Cover, is, in reality...
Asian Jasmine![/sub]

 

[AnotherHiggins]

Ok, how about
[COLOR=blue white]=if(len(a1)>50,"Keep","Junk")[/color]

[tt]_____
[blue]-John[/blue][/tt]

Help us help you. Please read FAQ181-2886 before posting.

 

[davesaint]

Thank you for your help. Works like a charm. Question - What does Len stand for?

 

[AnotherHiggins]

Length.

Have a look at Excel's help file for more info.

[tt]_____
[blue]-John[/blue][/tt]

Help us help you. Please read FAQ181-2886 before posting.