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 Search this Thread
Search this Thread:

Advanced Search

Similar help and support threads
Thread Forum
Can I compare 2 Excel spreadsheets cell by cell?
I have an Excel 2010 workbook comprising a simple organization membership list, consisting of names, addresses, etc., for nearly 2,000 members, grouped into 5 chapters' sheets, in a single Excel 2010 file. Every time I sit down to enter updates for any member, or add new members, etc., I always ...
Microsoft Office
6 Cell Vs 9 Cell Battery for Laptop?
Someone needs to get a new battery for a very old laptop they have. The battery doesn't work so they have to have it plugged all the time otherwise it wouldn't work. Laptop is 15.6 and sort of heavy but the thing is they never take the laptop outside the house. It will mainly be used on one floor...
Hardware & Devices
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...
Splinter Cell
NOTE: This is not the same issue that was posted in an earlier Chaos Theory thread. I am really new to Windows7, but here is my problem. I just downloaded and paid for a digital copy of Splinter Cell Chaos Theory off of Gamestop. Simple enough; went online, spent 9 dollars, downloading no...
Foreign Characters/Characters appearing.
Hi there. This is an odd problem, whenever certain characters are used ("^ are just some) then a letter is pressed foreign characters appear. I.E When I press " Then O it comes up as , instead of "O, and so on. Does anyone have any ideas, on how this could be fixed. I've checked in the...
Hardware & Devices

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 15:06.

Twitter Facebook Google+

Windows 7 Forums

Seven Forums Android App Seven Forums IOS App