Excel to Text File problem


New Member
Oct 31, 2017
I am trying to export my worksheet to excel as a text file. I was told to use ADD-INS write to text; although I have no idea how to get "write to text" on my add-in tab. So instead what I have done is just save it as a text file although this is not what I want. I want a text file that has commas and spaces in it. So if I save is as a CVS file I get the commas and no spaces. If I save it as the text file I get spaces and no commas. Unfortunately I need both commas and spaces and I need it to be saved as a text file.

For simplicity:

Currently looks like saved as a CVS:

(This would be ideal if it was a text file and there was space in between the commas)

Currently looks like saved as a text file:
1-Yr 2-Yr 3-Yr
Red Yellow Blue
Car Train Bus

(Sometimes the tabs get messed up so you have to go in an align, this would be ideal if I didn't have to align them and if there were commas in between the words)

What I need:

1-Yr ,2-Yr ,3-Yr
Red ,Yellow ,Blue
Car ,Train ,Bus

If anyone knows how to get the write to text add-in or how to save this as a text file with commas and space in between the commas please let me know. I would appreciate any and all help. Thank you for your time.

Scott Huish

MrExcel MVP
Mar 17, 2004
What range is your data in? I would write a macro to do this. It's an odd format anyway with the space preceding the comma rather than after it.

Forum statistics

Latest member

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...