Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
hello to you all....
well im sorry to disturb you with something so easily answered. i got string and need to know the number of caracter it contain.... as in "I need help" is 11 caracter long .... blank space must b counted. how do i code this (in VB) ? Thank -- Message posted from http://www.ExcelForum.com |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Sub FindLength()
Dim StringLength As Integer StringLength = Len("I need help") MsgBox StringLength End Su -- Message posted from http://www.ExcelForum.com |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
geez i knew it was something easy... i was trying with :
length(expression) thank for the help.... 3-4 year without programming are taking thei due on my skill... i'm soo ashamed... but still thank a lot for the help ma -- Message posted from http://www.ExcelForum.com |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
sStr = "A B C D"
lVar = len(sStr) -- Regards, Tom Ogilvy "Yan Robidoux " wrote in message ... hello to you all.... well im sorry to disturb you with something so easily answered. i got a string and need to know the number of caracter it contain.... as in "I need help" is 11 caracter long .... blank space must be counted. how do i code this (in VB) ? Thanks --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Zero length string on chart | Charts and Charting in Excel | |||
Zero-Length string vs Zero (also a valid value) | Excel Worksheet Functions | |||
Finding a string of unknown length in a string of unknown length, Help! | Excel Discussion (Misc queries) | |||
String length | Excel Discussion (Misc queries) | |||
Counting string length | Excel Programming |