| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
String length
what function do you use to return the length of a string in a cell???
EX. SomeString = length is 10 characters long. Thanks, Josh |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
String length
Use the LEN function to return the length of a string value
=LEN(A1) Returns the length of the string in cell A1 -- Kevin Backmann "jxbeeman" wrote: what function do you use to return the length of a string in a cell??? EX. SomeString = length is 10 characters long. Thanks, Josh |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Limit to string length in search@replace? | Excel Discussion (Misc queries) | |||
| creating numbers to a fixed length string... | Excel Worksheet Functions | |||
| Macro syntax to check string length in a cell | Excel Discussion (Misc queries) | |||
| length of text string goes beyond cells are not visible | Excel Discussion (Misc queries) | |||
| fixed string length,even other record is copied | Excel Discussion (Misc queries) | |||
Linear Mode
