Tink

Posts: n/a

Problem with counting characters in a cell

Hi,

I'm trying to count the number of characters in a cell. At the moment i've
tried using =LEN(A2). This works fine when all characters are numeric, but
when there are letters in the mix, it shows the total number as 30 regardless
of whether there are 8, 12 or 14 characters in the code.

Someone please help!!!

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Cell problem	Patrick	Excel Worksheet Functions	3	March 29th 05 03:33 PM
counting Multiple answers in 1 cell + column	the6thlee	Excel Discussion (Misc queries)	1	February 21st 05 09:19 AM
counting Multiple answers in 1 cell + column	help me i have an excel problem	Excel Discussion (Misc queries)	0	February 21st 05 08:41 AM
limit number of characters in a cell	abfabrob	Excel Discussion (Misc queries)	9	February 11th 05 04:19 PM
#### error if cell has more than 255 characters	Budalacovyek	Excel Discussion (Misc queries)	1	December 8th 04 06:42 PM

All times are GMT +1. The time now is 07:06 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us