Delimited to Text

[AthmanArumugam]

Hi,

I am aware of the feature in excel where it converts a delimited text [with "|" or tab] into separate columns in excel. Is there any feature where I could convert the data available in various columns back into a delimited text.

I want to convert the data in the attached file into a delimited text file.

 

[NARAYANK991]

Hi ,

Check out this link :

http://optimalbi.com/blog/2015/07/1...imited-file-rather-than-comma-delimited-file/

Narayan

 

[AthmanArumugam]

Or should I create a macro to do that.

 

[AthmanArumugam]

Hi ,

Check out this link :

http://optimalbi.com/blog/2015/07/1...imited-file-rather-than-comma-delimited-file/

Narayan

Thanks Narayana. It works.