Search:

Type: Posts; User: JeffreyWeir

Search: Search took 0.01 seconds.

  1. It turned out that this alternative version that...

    It turned out that this alternative version that takes the length of the string into consideration is slightly more efficient over 1000 rows of sample data:
    ...
  2. Replies
    5
    Views
    32,692

    It turned out that the generalized alternative...

    It turned out that the generalized alternative version that takes the length of the string into consideration i.e. this one

    =TRIM(MID(SUBSTITUTE(Text,Delim,REPT("...
  3. Replies
    5
    Views
    32,692

    Hi Rick. Re your comment ...I guess one could...

    Hi Rick. Re your comment
    ...I guess one could always set that multiplier dynamically e.g.:

    =TRIM(MID(SUBSTITUTE(Text,Delim,REPT(" ",LEN(Text))),element*LEN(Text)-(LEN(Text)-1),LEN(Text)))...
Results 1 to 3 of 3