You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser.
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.
Home Premium 64 bit2.9 gigahertz Intel Core2 Duo 64 kilobyte pri...4096 Megabytes Usable Installed Memory Slot '...ATI Radeon HD 4300/4500 Series - Computer type
- PC/Desktop
- Computer Manufacturer/Model Number
- Dell Inspiron 560MT
- OS
- Home Premium 64 bit
- CPU
- 2.9 gigahertz Intel Core2 Duo 64 kilobyte primary memory cac
- Motherboard
- Board: Dell Inc. 0K83V0 A00 Serial Number: ..CN750939CP069B
- Memory
- 4096 Megabytes Usable Installed Memory Slot 'DIMM0' has 102
- Graphics Card(s)
- ATI Radeon HD 4300/4500 Series
- Sound Card
- High Definition Audio Device NVIDIA High Definition Audio (
- Monitor(s) Displays
- DELL ST2210 [Monitor] (21.7"vis, s/n P479R01Q0VCU, January 2
- Screen Resolution
- 1920x1080
- Hard Drives
- 628.58 Gigabytes Usable Hard Drive Capacity
554.78 Gigabytes Hard Drive Free Space
- Keyboard
- Std Dell UK
- Mouse
- KEYBOARD, 105, UNITED KINGDOM, KWE9C0
- Internet Speed
- ~8000 kbps
- Antivirus
- Avast Free
- Browser
- Chrome
- Other Info
- Office 2007: Photo Editing; Serif PhotoPlus X7
Presumably you mean in Excel? If so, the LEN function still returns the number of characters in a text string, under Windows 7
Windows 7 Enterprise x64Intel i7 9206 GBnVidia GTX260 + nVidia 3D - Computer Manufacturer/Model Number
- Custom
- OS
- Windows 7 Enterprise x64
- CPU
- Intel i7 920
- Motherboard
- Asus P6T Deluxe v2
- Memory
- 6 GB
- Graphics Card(s)
- nVidia GTX260 + nVidia 3D
- Sound Card
- Onboard
- Monitor(s) Displays
- Samsung SyncMaster 2233RZ
- Screen Resolution
- 1680 x 1050
- Hard Drives
- 1 x 64GB SSD primary
2 x 1 TB (mirrored)
- PSU
- 700W
- Other Info
- Edimax 802.11n Wireless PCI Card
Netgear DG834G router
New member
Member
VIP
Thread Starter
Yes, Excel 2007
By happenstance I found it late last evening. The numbers revealed were much greater than the actual visible characters.
Home Premium 64 bit2.9 gigahertz Intel Core2 Duo 64 kilobyte pri...4096 Megabytes Usable Installed Memory Slot '...ATI Radeon HD 4300/4500 Series - Computer type
- PC/Desktop
- Computer Manufacturer/Model Number
- Dell Inspiron 560MT
- OS
- Home Premium 64 bit
- CPU
- 2.9 gigahertz Intel Core2 Duo 64 kilobyte primary memory cac
- Motherboard
- Board: Dell Inc. 0K83V0 A00 Serial Number: ..CN750939CP069B
- Memory
- 4096 Megabytes Usable Installed Memory Slot 'DIMM0' has 102
- Graphics Card(s)
- ATI Radeon HD 4300/4500 Series
- Sound Card
- High Definition Audio Device NVIDIA High Definition Audio (
- Monitor(s) Displays
- DELL ST2210 [Monitor] (21.7"vis, s/n P479R01Q0VCU, January 2
- Screen Resolution
- 1920x1080
- Hard Drives
- 628.58 Gigabytes Usable Hard Drive Capacity
554.78 Gigabytes Hard Drive Free Space
- Keyboard
- Std Dell UK
- Mouse
- KEYBOARD, 105, UNITED KINGDOM, KWE9C0
- Internet Speed
- ~8000 kbps
- Antivirus
- Avast Free
- Browser
- Chrome
- Other Info
- Office 2007: Photo Editing; Serif PhotoPlus X7
