Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi Folks,
I'd like to remove the last character of each value of an array (the last character is a comma i.e. ,). Below is what I have come up with and it does not work. The array name is logical_layer1...any pointers will be appreciated. Thanks. For arraynumber = 1 To UBound(logical_layer1) string1(arraynumber) = Right(logical_layer1(arraynumber), 1) If string1(arraynumber) = "," Then logical_layer1(arraynumber) = Left((logical_layer(arraynumber)), Len((logical_layer(arraynumber)) - 1)) End If Next arraynumber |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Remove character at end of data | Excel Discussion (Misc queries) | |||
How to remove character format under .csv? | Excel Discussion (Misc queries) | |||
Remove Left Most character | Excel Programming | |||
How to remove a character from the first index? | Excel Discussion (Misc queries) | |||
Remove a particular character using formulas | Excel Discussion (Misc queries) |