Microsoft Excel Formula need help

[Tigerwoods]

Hi Excel experts,

I see recently some of you gave some solutions to excel formula so I hope someone can help me.

 

I'm a novice.

 

I would like to have a forumula that counts the Characters in a Cell.

 

Say : A1B2C3 means there are 6 characters, what formula to use to count it ??

 

Thanks,

[EllaEmma]

=LEN(YOUR CELL)

[Kxbc]

Learnt something new. Not that I will use this function. Anyway, in everyday context, what is this LEN function good for?

[Passion]

use for extract of alphabet.Some for people who want to know the length of other countries telephone length,or in some formatted string,you want to extract certain field starting from say 9th character. You do a =len() the string, then if you want the first string starting from 9th character to the last one,you can do a =right(cell 1,len(cell1)-9) . then you can extract the string after the 9th alphabet.

[Kxbc]

Thanks. Seems like my excel skills are very mediocre. I do not know of the Right function as well.

[Typhoonz]

Learnt something new today...

[Tigerwoods]

I have to CONCATENATE 5 cells into 1 to get a Part Number and only when the No. of Characters reach 10 means the Part number is complete and I'd like to register the complete part into another cell.

 

Example :

Cell A1

ABCDE12345 means 10 characters => =IF(LEN(A1)=10,A1,"")

 

[Tigerwoods]

Thanks !!! I remember this function !!!

[Robo]

wah... i didnt even know excel got this function!

 

learnt smth new..

[EllaEmma]

Excel is quite powerful, if you know its capability.

For those who has crosstab reporting needs, you can use Pivot Table, a very useful feature of Excel.

[Mightymito]

press ctrl+alt+del

[Aimnfire]

  On 9/28/2010 at 5:07 AM, EllaEmma said:

Excel is quite powerful, if you know its capability.

For those who has crosstab reporting needs, you can use Pivot Table, a very useful feature of Excel.

 

wowwwwwwwwww

thank you;p