|
-
Oct 7th, 2005, 12:14 PM
#1
Thread Starter
Hyperactive Member
Simple Replace (Resolved)
i have a list of words in list1 that all have spaces at the end. and i want to remove the spaces. But keep them in the same list box.
Thanks.
Last edited by Ricky1; Oct 7th, 2005 at 12:44 PM.
-
Oct 7th, 2005, 12:15 PM
#2
Thread Starter
Hyperactive Member
Re: Simple Replace
just spaces at the end. No where else.
-
Oct 7th, 2005, 12:16 PM
#3
Re: Simple Replace
Use Trim when you add them to the listbox.
-
Oct 7th, 2005, 12:17 PM
#4
Thread Starter
Hyperactive Member
Re: Simple Replace
wouldn't trim remove the last letter no matter what it was? because not all the words do have spaces at the end.
-
Oct 7th, 2005, 12:18 PM
#5
Thread Starter
Hyperactive Member
Re: Simple Replace
Code:
If Right(list1.list(i), 1) = " " Then
list1.list(i) = list1.list(i) - Right(list1.list(i)
End If
Soemthing like that ??
-
Oct 7th, 2005, 12:19 PM
#6
Re: Simple Replace
LTrim removes leading spaces, RTrim removes trailing spaces and Trim removes both.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|