LEN()?

[Ian Mac]

Is there a way of counting the number of characters in multipal cells

i.e. =LEN(I7:K7)

Thanks

 

[Aladin Akyurek]

On 2002-02-26 02:38, Ian Mac wrote:
Is there a way of counting the number of characters in multipal cells

i.e. =LEN(I7:K7)

Thanks

Hi Ian,

=SUMPRODUCT(LEN(I7:K7))

Aladin

 

[Ian Mac]

Many Thanks Aladin,

Can't see the wood for the trees today.

Thanks again

 

[Ian Mac]

Again Thank Aladin,

thought I'd show off and let you see what you helped me with.
It's a formula separate (eg):

A Place/Operations Agent/Dummy Project/Data Capture/John Smith/AAA/T1

I used:

=LEFT(E7,FIND("/",E7)-1) Standard stuff

then:

=LEFT(MID($E9,(SUMPRODUCT(LEN($F9:F9))+COUNTA($F9:F9))+1,100),FIND("/",MID($E9,(SUMPRODUCT(LEN($F9:F9))+COUNTA($F9:F9))+1,100))-1)

to just drag across.

Thanks I feel good now.

Ian