Export to .txt with only 1 space

Hello

I have a series of data that looks like this:

A	B
20070301	000005;0.92106;1
20070301	000010;0.92105;1
20070301	000011;0.92105;1
20070301	000017;0.921;1

(Column A does change, just not for several hundred rows later)

Currently, when I try to export this to a .txt. file, I get this:

20070301 000005;0.92106;1
20070301 000010;0.92105;1
20070301 000011;0.92105;1
20070301 000017;0.921;1

but, I need it to be:

20070301 000005;0.92106;1
20070301 000010;0.92105;1
20070301 000011;0.92105;1
20070301 000017;0.921;1

It can only be 1 space between column A and column B.

I have tried a couple of other methods and it produced having no spaces between column A and B.

does anybody have any suggestions?

Thank you very much for your help!!

Looks same for me

oh, i should have previewed the post. the forum didn't except my multiple spaces.

In short, the first had several spaces between and the second has only 1 space in between.

I am attaching a screenshot of the .txt file.

this is only a small sample of several files that literally total millions of excel rows.

Maybe to add one more column as

Formula:

Please Login or Register  to view this content.

and then print that column to txt?

Please Login or Register  to view this content.

That was definitely a solution. Thank you very much

I have never taken the time to learn how to create Macros - but this inspires me to take the time to learn it.

Thanks!

Are you sure that's not a TAB instead of spaces? The default delimiter between cells in excel is a tab.