| 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 |
| 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) | |||
Threaded Mode
