Function to return number of characters in cell?


  1. rundwald
    Posts : 394
    Home Premium 64 bit
       New #1

    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 Computer
    Quote Quote

  3. clunkfish
    Posts : 295
    Windows 7 Enterprise x64
       New #2

    Presumably you mean in Excel? If so, the LEN function still returns the number of characters in a text string, under Windows 7 :)
      My Computer
    Quote Quote

  4. rundwald
    Posts : 394
    Home Premium 64 bit
    Thread Starter
       New #3

    Yes, Excel 2007

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

 

  Related Discussions
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...
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...
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.
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
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 06:25.
Find Us