I need a formula to help me count !!!

Lurchybold

New Member
Joined
Nov 23, 2005
Messages
29
Hi,

I'm new to this so don't really know how this works or if anyone will be able to help.

I'm sure this is a really simple formula but if you don't know then you don't know and unfortunately I'm most definately in that catagory.

I have nearly 6,000 items to sort through and get the descriptions down to 24 characters or less (including spaces). I need a formula that will tell me in one cell how many characters and spaces are in another cell. Otherwise I'm counting them by hand.

Can anyone please help me with this request,

If not then thank's for your time and I'll see you in a couple of months when I've finished counting,

Cheers,

Andy.
 

Some videos you may like

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.

shodan

Active Member
Joined
Jul 6, 2005
Messages
481
do you need the total number of characters including spaces? than:

=len(a1)

Regards,
 

Lurchybold

New Member
Joined
Nov 23, 2005
Messages
29
Thank You so much

Hi,

thats brilliant,

I knew it would be simple and you 've saved me a lot of time,

Thank You so much,

Cheers,

Andy.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,082
Messages
5,570,095
Members
412,311
Latest member
Mozz
Top