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
rundwald

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
clunkfish

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
rundwald

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
.

Reply

 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...
Customization


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 23:01.
Twitter Facebook Google+ Seven Forums iOS App Seven Forums Android App