ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   string length (https://www.excelbanter.com/excel-programming/307462-string-length.html)

Yan Robidoux[_10_]

string length
 
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


Brassman[_4_]

string length
 
Sub FindLength()
Dim StringLength As Integer
StringLength = Len("I need help")
MsgBox StringLength
End Su

--
Message posted from http://www.ExcelForum.com


Yan Robidoux[_11_]

string length
 
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


Tom Ogilvy

string length
 
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/





All times are GMT +1. The time now is 08:39 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com