excel, it's pants

Reply Subscribe

Thread Tools

Search this Thread

12 February 2002, 05:21 PM

MattN

Scooby Regular

Thread Starter

Join Date: Nov 2000

Posts: 2,174

Likes: 0

Received 0 Likes on 0 Posts

is there a way of asking if a text string is a certain length then do something with it???

Reply Like

12 February 2002, 05:31 PM

Dunk

Scooby Regular

iTrader: (1)

Join Date: May 2001

Location: Berk (s)

Posts: 2,491

Likes: 0

Received 0 Likes on 0 Posts

The following will return "yes" if the number of characters in cell B5 is 12, or "no" if it doesn't.

=IF(LEN(B5)=12,"yes","no")

Hope this assists,

Dunk

Reply Like

12 February 2002, 05:37 PM

MattN

Scooby Regular

Thread Starter

Join Date: Nov 2000

Posts: 2,174

Likes: 0

Received 0 Likes on 0 Posts

I thought Len would work but I need a range and it doesn't seem to like it.

=IF(LEN(A1:A2091)=4,SUM(M1:M2091),0)

what I really want is

=SUMIF(A1:A2091, string =9 characters, M1:M2091) but don't know what the middle bit is.

Reply Like