Excel to Text File problem

[kam4b7]

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:
1-Yr,2-Yr,3-Yr
Red,Yellow,Blue
Car,Train,Bus

(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]

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.