Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I'm using a loop to build a string of characters but I'm getting extra
characters at the end that I don't want. Is there a function like trimend or regexp where I can take the string and remove the right most 3 characters? Here's an example: arraystring = "someword", "someword2", "someword3", "someword4", " I'd like it to change my arraystring to show just: "someword", "someword2", "someword3", "someword4" This doesn't seem to work for me: ArrayString = Trim(ArrayString, Right(Len(ArrayString) - 3)) I'm getting an error under the right() function. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Remove characters from string | Excel Programming | |||
Remove characters from string | Excel Programming | |||
Remove characters from string | Excel Programming | |||
Remove characters from string | Excel Programming | |||
Remove all characters following the first character in a string | Excel Discussion (Misc queries) |