# of letters in a string
 

Is there anyway to tell how many letters are in a string? More
specifically, I have a userform where the user enters a string into a
textbox. The textbox will only accept a total of 10 letters. When the
string variable gets passed to my sub routine, I need to know how many
letters are in that string.

If I can determine how many letters are in the string, if there are
less than 10, I then want to add spaces to the end of that string to
make it 10 characters long.

For example, if I enter:
"August" (6 characters) - it will then change it to "August____" (_ =
" ")
"California" (10 characters) - it will not add any spaces


TIA for any help,

DejaVu


--
DejaVu
------------------------------------------------------------------------
DejaVu's Profile: http://www.excelforum.com/member.php...o&userid=22629
View this thread: http://www.excelforum.com/showthread...hreadid=393382

# of letters in a string
 

sStr = Left(sStr & " ",10)

--
Regards,
Tom Ogilvy


"DejaVu" wrote in
message ...

Is there anyway to tell how many letters are in a string? More
specifically, I have a userform where the user enters a string into a
textbox. The textbox will only accept a total of 10 letters. When the
string variable gets passed to my sub routine, I need to know how many
letters are in that string.

If I can determine how many letters are in the string, if there are
less than 10, I then want to add spaces to the end of that string to
make it 10 characters long.

For example, if I enter:
"August" (6 characters) - it will then change it to "August____" (_ =
" ")
"California" (10 characters) - it will not add any spaces


TIA for any help,

DejaVu


--
DejaVu
------------------------------------------------------------------------
DejaVu's Profile:
http://www.excelforum.com/member.php...o&userid=22629
View this thread: http://www.excelforum.com/showthread...hreadid=393382

# of letters in a string
 

msgbox len(sStr) gives the number of characters in the string held in
variable sStr (just for completeness)

--
Regards,
Tom Ogilvy

"DejaVu" wrote in
message ...

Is there anyway to tell how many letters are in a string? More
specifically, I have a userform where the user enters a string into a
textbox. The textbox will only accept a total of 10 letters. When the
string variable gets passed to my sub routine, I need to know how many
letters are in that string.

If I can determine how many letters are in the string, if there are
less than 10, I then want to add spaces to the end of that string to
make it 10 characters long.

For example, if I enter:
"August" (6 characters) - it will then change it to "August____" (_ =
" ")
"California" (10 characters) - it will not add any spaces


TIA for any help,

DejaVu


--
DejaVu
------------------------------------------------------------------------
DejaVu's Profile:
http://www.excelforum.com/member.php...o&userid=22629
View this thread: http://www.excelforum.com/showthread...hreadid=393382

# of letters in a string
 

Or you could do the following:

sStr = sStr & Space(10 - Len(sStr))

"Tom Ogilvy" wrote:

sStr = Left(sStr & " ",10)

--
Regards,
Tom Ogilvy


"DejaVu" wrote in
message ...

Is there anyway to tell how many letters are in a string? More
specifically, I have a userform where the user enters a string into a
textbox. The textbox will only accept a total of 10 letters. When the
string variable gets passed to my sub routine, I need to know how many
letters are in that string.

If I can determine how many letters are in the string, if there are
less than 10, I then want to add spaces to the end of that string to
make it 10 characters long.

For example, if I enter:
"August" (6 characters) - it will then change it to "August____" (_ =
" ")
"California" (10 characters) - it will not add any spaces


TIA for any help,

DejaVu


--
DejaVu
------------------------------------------------------------------------
DejaVu's Profile:
http://www.excelforum.com/member.php...o&userid=22629
View this thread: http://www.excelforum.com/showthread...hreadid=393382

# of letters in a string
 

Thanks to both of you... your help is much appreciated.

DejaV

--
DejaV
-----------------------------------------------------------------------
DejaVu's Profile: http://www.excelforum.com/member.php...fo&userid=2262
View this thread: http://www.excelforum.com/showthread.php?threadid=39338