Linker IT Software
Order Home
menubar-top-links menubar-top-rechts
SQL*XL: Database to Excel bridge ExcelLock: Lock and secure your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe
Home Products litLIB Help String functions

Buy now

Download now

LITlib - Excel Power Functions Pack
 
Add-in for Excel that adds additional cell functions to Excel.

litLIB Help - SeparatedValues function
litLIB Help
Product pages :
litLIB
Quick links:
help index
forums

String - SeparatedValues

Syntax:
=SeparatedValues(Separator , Cells )

Description:
Returns a string that contains the values in the Cells given separated by the Separator string.

Example:
Suppose there are numbers in A1 to A10. We would like to show the numbers as a comma separated list.
=SeparatedValues("," , A1:A10)

litLIB