Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.

Windows 7: Function to return number of characters in cell?

21 Jul 2010   #1

Home Premium 64 bit
Function to return number of characters in cell?

IIRC in XP there used to be such a function (?LEN?), but so far I have not found its equivalent in Win7 .

Hopefully someone can assist.

My System SpecsSystem Spec
21 Jul 2010   #2

Windows 7 Enterprise x64

Presumably you mean in Excel? If so, the LEN function still returns the number of characters in a text string, under Windows 7 :)
My System SpecsSystem Spec
22 Jul 2010   #3

Home Premium 64 bit

Yes, Excel 2007

By happenstance I found it late last evening. The numbers revealed were much greater than the actual visible characters.
My System SpecsSystem Spec


 Function to return number of characters in cell?

Thread Tools

Similar help and support threads
Thread Forum
Sony Vaio E Event Service - Function Keys return to manual startup
I have a Sony Vaio E System Model SVE1511A1EW. I have noticed when I want to use the Function Keys F5 and F6 for brightness and F3 and F4 for volume the do not function at all. I have looked on google and found that in Administrative Tools, Services and then Vaio Event Service, this was set to...
General Discussion
Max. Number Of Characters Allowed In Names For A Transfer To Ext. HD ?
Hello, I tend to use pretty long file names on my Folders, and also, often for the WORD documents inside. When I try to transfer these to an external HD for backup, the following seems to happen. But, it is very inconsistent. Most of the time, but not all, it will ask me to if I want to...
General Discussion
Number of characters in Word text.
Word shows the number of words in the text on the state bar at the bottom. Can it be adjusted to show the number of characters? Thank you very much in advance.
Microsoft Office
Modify Number of Characters per Line on Desktop Icon
I need to figure out how to modify the number of characters that can fit on one line of a desktop icon. I tried to research beforehand of course, only to find that the most common remedy that "allegedly" works, is increasing the horizontal icon spacing value. I tried this, even to the max value it...

Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 11:41.
Twitter Facebook Google+