If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|