| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
# 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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
# 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
# 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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
# 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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
# 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formatting string in groups of letters... | Excel Worksheet Functions | |||
| Breaking a string of letters | Excel Discussion (Misc queries) | |||
| Breaking a string of letters | Excel Discussion (Misc queries) | |||
| Calculating number of letters in a string ... | Excel Discussion (Misc queries) | |||
| Calculating number of letters in a string ... | Excel Worksheet Functions | |||
![DejaVu[_43_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
