| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Number of Charachters in a cell
Hi guys!!! Easy one - how do you count the numbers of charachters with a cell? Thanks D *** Sent via Developersdex http://www.developersdex.com *** |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Number of Charachters in a cell
Hi Darin,
Easy one - how do you count the numbers of charachters with a cell? =len(a1) arno |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Number of Charachters in a cell
use LEN()
e.g. LEN(A1) - Mangesh "Darin Kramer" wrote in message ... Hi guys!!! Easy one - how do you count the numbers of charachters with a cell? Thanks D *** Sent via Developersdex http://www.developersdex.com *** |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Number of Charachters in a cell
Anyone know why LEN and LENB return the same number on my English
W2K/Office2000 with Chinese text (i.e. both return the number of characters) but return the correct numbers (i.e.characters & bytes repectively) on my Chinese W2K/Office2000 with Chinese text. NickHK "arno" wrote in message ... Hi Darin, Easy one - how do you count the numbers of charachters with a cell? =len(a1) arno |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula based on first two charachters of a cell | Excel Worksheet Functions | |||
| Alpha Charachters in Format Cells Custom | Excel Worksheet Functions | |||
| Random cell/number and dont repeat selected cell/number | Excel Discussion (Misc queries) | |||
| formula for counting charachters in a cell ? | Excel Discussion (Misc queries) | |||
| reduce # of charachters in same cell | Excel Worksheet Functions | |||
Linear Mode
