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:
...
Type: Posts; User: JeffreyWeir
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:
...
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("...
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)))...