Export to the text file with space separator

If I save excel file as a text file, I don't have possibility to save it with the space separator but just with the tab separator. There exists some macro which will be able to save my file like this? (I used _ as a space)

10_255,00_345,00
115_3450,00_1981,00

instead of this (I used _ which means tabulator in this case):

10__255,00__345,00
115_3450,00_1981,00

This is what I don't what...I need space delimiter not Tab delimiter

See edit in my post.

mgecelov
Try this

Please Login or Register  to view this content.

thanks so much. It works perfectly. If I may ask one more question, when I do need numbers with two decimals 255.00...not just 255...what is the result of your code?

Then Text property for the safety.

Please Login or Register  to view this content.

many thanks