Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a subroutine that results in different string lengths sorted in
ascending order that come from the tabnames in a workbook like the following: 12345, ,12345, 12346, , 12345,,12346, 12347, V01234, V02345, 12346, 12347, When a leading comma appears, it's from a tabname that exists but doesn't meet the criteria for the string and the string ends with a comma. How do I ReDim or reformat the string to eliminate the leading, trailing and intermediate double commas? Also, if only one tabname appears in the string, I want to delete that one entirely. The items with V can sort to the end of the string or if with a leading zero and the V is absent, then they sort to the beginning. . . The list should look like a standard CSV list in a string like line 3 above but no ending or intermediate comma. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Counting No of character in a string | Excel Worksheet Functions | |||
Stepping through each character in a character string | Excel Programming | |||
Excel-Match 1st text character in a string to a known character? | Excel Worksheet Functions | |||
Function to return Character Position of Xth character within a string | Excel Programming | |||
Sorted Fixed Length String | Excel Programming |