Documentation for smfJoin() function
Description
A utility function to join (i.e. "concatenate") a range of data together.
Syntax
=smfJoin( Range, Delimiter )
Parameters
Range
= a range of EXCEL cells to concatenate together.
Delimiter
= a string to put in between each cell of the range when joining them.
Examples
If cells G1 thru G5 contain the letters "A" thru "E", then:
=smfJoin(G1:G5,",")
...would create a string of "A,B,C,D,E".
If cells G1 thru G5 contain the numbers 11 thru 15, then:
=smfJoin(G1:G5,";")
...would create a string of "11;12;13;14;15".
If cells G1 thru G8 contain eight ticker symbols, then:
="http://stockcharts.com/freecharts/candleglance.html?"&smfJoin;(G1:G8,",")&"|B|B2"
...would create something like this URL:
http://stockcharts.com/freecharts/candleglance.html?MMM,IBM,AA,SPY,IWM,DIA,NFLX,JNJ|B|B2
.
...more to come?
Usage notes
None at this time...