LEN()?

Ian Mac · Feb 26th, 2002, 03:38 AM

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

i.e. =LEN(I7:K7)

Thanks

Aladin Akyurek · Feb 26th, 2002, 03:42 AM

Quote:

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 · Feb 26th, 2002, 03:44 AM

Many Thanks Aladin,

Can't see the wood for the trees today.

Thanks again

Ian Mac · Feb 26th, 2002, 03:59 AM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 26th, 2002, 03:38 AM	#1
Ian Mac MrExcel MVP Join Date: Feb 2002 Location: Newcastle, UK Posts: 1,174	Is there a way of counting the number of characters in multipal cells i.e. =LEN(I7:K7) Thanks

Feb 26th, 2002, 03:44 AM	#3
Ian Mac MrExcel MVP Join Date: Feb 2002 Location: Newcastle, UK Posts: 1,174	Many Thanks Aladin, Can't see the wood for the trees today. Thanks again

Feb 26th, 2002, 03:59 AM	#4
Ian Mac MrExcel MVP Join Date: Feb 2002 Location: Newcastle, UK Posts: 1,174	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