# Anyone Know How To Convert Column To Delimited Data? **URL:** \ **Category:** The Free For All Lounge\ **Created:** [April 9, 2017, 11:23pm UTC](https://mpsocial.com/t/anyone-know-how-to-convert-column-to-delimited-data/10707 "2017-04-09T23:23:36Z")\ **Posts on this page:** 18\ **Page:** 1
**Author:** ![BrandonBerner](https://mpsocial.com/user_avatar/mpsocial.com/brandonberner/32/9354_2.png) [@BrandonBerner](https://mpsocial.com/u/BrandonBerner)\ **Post date:** [April 9, 2017, 11:23pm UTC](https://mpsocial.com/t/anyone-know-how-to-convert-column-to-delimited-data/10707/1 "2017-04-09T23:23:36Z")
I am currently using [http://delim.co/#](http://delim.co/#) to convert my Column Data to Delimited Data. The problem with this website is that it will freeze or take a long time for it to convert. I am assuming this is their server, or a limitation in chrome. Its not my server since it has 256GB RAM and a very fast processor. When using this website, my ram and CPU do not even reach 5% usage. Im looking for a solution to convert at a faster rate since its lowering productivity. I would assume a software would acheive this much faster. Any ideas? ---
**Author:** ![MojoJojo](https://mpsocial.com/user_avatar/mpsocial.com/mojojojo/32/1246_2.png) [@MojoJojo](https://mpsocial.com/u/MojoJojo)\ **Post date:** [April 9, 2017, 11:26pm UTC](https://mpsocial.com/t/anyone-know-how-to-convert-column-to-delimited-data/10707/2 "2017-04-09T23:26:26Z")
How about Excel? You can build / get someone to build you a quick macro and just press a button and you are done. ---
**Author:** ![BrandonBerner](https://mpsocial.com/user_avatar/mpsocial.com/brandonberner/32/9354_2.png) [@BrandonBerner](https://mpsocial.com/u/BrandonBerner)\ **Post date:** [April 9, 2017, 11:34pm UTC](https://mpsocial.com/t/anyone-know-how-to-convert-column-to-delimited-data/10707/3 "2017-04-09T23:34:02Z")
> [@MojoJojo](#): > > How about Excel? > > You can build / get someone to build you a quick macro and just press a button and you are done. Sure why not! Thats great. Is anyone willing to create this for me? If so name your price 🙂 ---
**Author:** ![Said](https://mpsocial.com/user_avatar/mpsocial.com/said/32/11294_2.png) [@Said](https://mpsocial.com/u/Said)\ **Post date:** [April 9, 2017, 11:40pm UTC](https://mpsocial.com/t/anyone-know-how-to-convert-column-to-delimited-data/10707/4 "2017-04-09T23:40:23Z")
Did you try to open the file using Notepad ++? and then find ; and replace it with , and click on replace all? ---
**Author:** ![dddd](https://mpsocial.com/user_avatar/mpsocial.com/dddd/32/11519_2.png) [@dddd](https://mpsocial.com/u/dddd)\ **Post date:** [April 9, 2017, 11:41pm UTC](https://mpsocial.com/t/anyone-know-how-to-convert-column-to-delimited-data/10707/5 "2017-04-09T23:41:50Z")
Take a look at [How to convert column list to comma-separated list in Excel?](https://www.extendoffice.com/documents/excel/1544-excel-convert-column-to-comma-separated-list.html) Theres a 60 day trial, otherwise the VBA function is free Btw, i don’t have any issues with browser converter at [Convert Column to Comma Separated List Online](https://convert.town/column-to-comma-separated-list) ![](https://mpsocial.com/uploads/default/original/2X/7/7fab666b432956b1bf773ca644810fac0e36f253.png) At [delim.co](http://delim.co) i can process 12800 just fine. ![](https://mpsocial.com/uploads/default/original/2X/a/a1a9929811f792b403d8283d3d4074e46aab7b04.png) ---
**Author:** ![MojoJojo](https://mpsocial.com/user_avatar/mpsocial.com/mojojojo/32/1246_2.png) [@MojoJojo](https://mpsocial.com/u/MojoJojo)\ **Post date:** [April 9, 2017, 11:42pm UTC](https://mpsocial.com/t/anyone-know-how-to-convert-column-to-delimited-data/10707/6 "2017-04-09T23:42:01Z")
Don’t have the know-how to automate it into a macro but here’s the manual process: hashtag + , = hashtag, \> concatenate + transpose = desired result. ---
**Author:** ![BrandonBerner](https://mpsocial.com/user_avatar/mpsocial.com/brandonberner/32/9354_2.png) [@BrandonBerner](https://mpsocial.com/u/BrandonBerner)\ **Post date:** [April 9, 2017, 11:45pm UTC](https://mpsocial.com/t/anyone-know-how-to-convert-column-to-delimited-data/10707/7 "2017-04-09T23:45:22Z")
> [@Said](#): > > Did you try to open the file using Notepad ++? and then find ; and replace it with , and click on replace all? The column data looks like this: word word word word There are no ; so I cant find and replace anything ☹ Thanks for trying to help! 😃 ---
**Author:** ![Said](https://mpsocial.com/user_avatar/mpsocial.com/said/32/11294_2.png) [@Said](https://mpsocial.com/u/Said)\ **Post date:** [April 9, 2017, 11:46pm UTC](https://mpsocial.com/t/anyone-know-how-to-convert-column-to-delimited-data/10707/8 "2017-04-09T23:46:20Z")
@BrandonBerner Maybe you can upload a sample file here to take a look at it 😛 ---
**Author:** ![benny](https://mpsocial.com/user_avatar/mpsocial.com/benny/32/11175_2.png) [@benny](https://mpsocial.com/u/benny)\ **Post date:** [April 9, 2017, 11:47pm UTC](https://mpsocial.com/t/anyone-know-how-to-convert-column-to-delimited-data/10707/9 "2017-04-09T23:47:25Z")
> [@BrandonBerner](#): > > Is anyone willing to create this for me I’ll do it. Excel is very powerful and can do this for sure ---
**Author:** ![insomnijak](https://mpsocial.com/user_avatar/mpsocial.com/insomnijak/32/820_2.png) [@insomnijak](https://mpsocial.com/u/insomnijak)\ **Post date:** [April 9, 2017, 11:59pm UTC](https://mpsocial.com/t/anyone-know-how-to-convert-column-to-delimited-data/10707/10 "2017-04-09T23:59:26Z")
Brandon, I guess you have hashtags in a column and you want them coma separated for MP? I do this in less then a minute using LibreOffice Calc. Here is how: 1. Copy all hashtags from a column 2. Paste special, choose option “transpose” 3. Now you pasted all hashtags to horizontal cells. Choose “merge and center” click yes 4. Now you have all hashtags in one cell, divided by 1 empty space. 5. Choose Edit (from top left menu) then “find&replace” 6. In find, choose empty space by pressing space 7. In replace, choose , (in case you do not see it, it is coma) 8. Now you have all hashtags coma separated (only first one does not have it, add it manually) Enjoy ---
**Author:** ![BrandonBerner](https://mpsocial.com/user_avatar/mpsocial.com/brandonberner/32/9354_2.png) [@BrandonBerner](https://mpsocial.com/u/BrandonBerner)\ **Post date:** [April 10, 2017, 12:05am UTC](https://mpsocial.com/t/anyone-know-how-to-convert-column-to-delimited-data/10707/11 "2017-04-10T00:05:32Z")
> [@dddd](#): > > Btw, i don’t have any issues with browser converter at [Convert Column to Comma Separated List Online](https://convert.town/column-to-comma-separated-list) Your a live saver! This worked instantly, and no need to install excess hardware or macro scripts 😃 I tried so many online converters, and never found this gem. Thanks @dddd 😃 😃 😃 ---
**Author:** ![BrandonBerner](https://mpsocial.com/user_avatar/mpsocial.com/brandonberner/32/9354_2.png) [@BrandonBerner](https://mpsocial.com/u/BrandonBerner)\ **Post date:** [April 10, 2017, 12:06am UTC](https://mpsocial.com/t/anyone-know-how-to-convert-column-to-delimited-data/10707/12 "2017-04-10T00:06:13Z")
Thanks @MojoJojo @Said @benny @insomnijak for your help also! ---
**Author:** ![Said](https://mpsocial.com/user_avatar/mpsocial.com/said/32/11294_2.png) [@Said](https://mpsocial.com/u/Said)\ **Post date:** [April 10, 2017, 12:20am UTC](https://mpsocial.com/t/anyone-know-how-to-convert-column-to-delimited-data/10707/13 "2017-04-10T00:20:36Z")
@BrandonBerner You need to buy @dddd coffee for life 😂 ---
**Author:** ![benny](https://mpsocial.com/user_avatar/mpsocial.com/benny/32/11175_2.png) [@benny](https://mpsocial.com/u/benny)\ **Post date:** [April 10, 2017, 12:27am UTC](https://mpsocial.com/t/anyone-know-how-to-convert-column-to-delimited-data/10707/14 "2017-04-10T00:27:21Z")
If you still have some use for it, just let me know and I’ll send it. It took just 10 minutes to complete. Excel rules! ---
**Author:** ![BrandonBerner](https://mpsocial.com/user_avatar/mpsocial.com/brandonberner/32/9354_2.png) [@BrandonBerner](https://mpsocial.com/u/BrandonBerner)\ **Post date:** [April 10, 2017, 12:30am UTC](https://mpsocial.com/t/anyone-know-how-to-convert-column-to-delimited-data/10707/15 "2017-04-10T00:30:38Z")
> [@Said](#): > > You need to buy @dddd coffee for life 😂 Hahaha for sure! @DDDD Do you want a coffee? Send me your PayPal Email 😃 ---
**Author:** ![BrandonBerner](https://mpsocial.com/user_avatar/mpsocial.com/brandonberner/32/9354_2.png) [@BrandonBerner](https://mpsocial.com/u/BrandonBerner)\ **Post date:** [April 10, 2017, 12:50am UTC](https://mpsocial.com/t/anyone-know-how-to-convert-column-to-delimited-data/10707/16 "2017-04-10T00:50:43Z")
> [@benny](#): > > If you still have some use for it, just let me know and I’ll send it.It took just 10 minutes to complete.Excel rules! Sure why not 😃 If you post it publicly im sure others may benefit from it also. > [@benny](#): > > It took just 10 minutes to complete.Excel rules! Haha you are an Excel wizard 🙂 I am always blown away with what excel can do. ---
**Author:** ![wortime](https://mpsocial.com/user_avatar/mpsocial.com/wortime/32/30775_2.png) [@wortime](https://mpsocial.com/u/wortime)\ **Post date:** [April 10, 2017, 6:49am UTC](https://mpsocial.com/t/anyone-know-how-to-convert-column-to-delimited-data/10707/17 "2017-04-10T06:49:50Z")
![](https://mpsocial.com/uploads/default/original/2X/8/8fc0819416a4afca8dfea6f8e1ca7301c7ba79be.jpg) ---
**Author:** ![Gernozarus](https://mpsocial.com/user_avatar/mpsocial.com/gernozarus/32/9795_2.png) [@Gernozarus](https://mpsocial.com/u/Gernozarus)\ **Post date:** [April 10, 2017, 5:12pm UTC](https://mpsocial.com/t/anyone-know-how-to-convert-column-to-delimited-data/10707/19 "2017-04-10T17:12:04Z")
There was also this post: [http://mpsocial.com/t/free-excel-convert-rows-to-comma-delimited-for-hashtags-etc/10758?u=gernozarus&source\_topic\_id=10707](https://mpsocial.com/t/free-excel-convert-rows-to-comma-delimited-for-hashtags-etc/10758?u=gernozarus&source_topic_id=10707)