View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Richard RE Richard RE is offline
external usenet poster
 
Posts: 2
Default 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