Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Convert column data to semicolon delimited text string
Hi,
I want to convert a column with let's say about 900 hundred rows with data (numbers) into a single string, where the rows data are semicolon delimited. How can I manage this? Example: column1 row1 123 row2 456 row3 876 row4 345 into a single string (semicolon delimited): 123;456;876;345 thanks for any help in advance! //Richard |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Convert column data to semicolon delimited text string
You can use the following UDF. Then within your sheet enter the formula:
=DelimCat(A1:A10,";") Function DelimCat(rng As Range, delim As String) For Each rn In rng temp = temp & rn & delim Next DelimCat = Left(temp, Len(temp) - 1) End Function -- Regards, Dave "Richard RE" wrote: Hi, I want to convert a column with let's say about 900 hundred rows with data (numbers) into a single string, where the rows data are semicolon delimited. How can I manage this? Example: column1 row1 123 row2 456 row3 876 row4 345 into a single string (semicolon delimited): 123;456;876;345 thanks for any help in advance! //Richard |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I convert text string into a cell reference | Excel Discussion (Misc queries) | |||
Macro to find text string in a column and paste data in another | Excel Discussion (Misc queries) | |||
how do Import data tab delimited text? | Excel Worksheet Functions | |||
convert text to number for a range of data in a column | Excel Discussion (Misc queries) | |||
How do I strip out some parts of a column of text data? | Excel Discussion (Misc queries) |