Hello susan santa 12345

This is potentially quite easy if you know a couple of things about your text file
_ 1 the format on the character(s) used as the line separator
_ 2 how consistent that character(s) used as the line separator is.

To explain what I am talking about:
In computing generally, and certainly in text files, a computer knows when to make a new line in text when it sees 1 or 2 specific characters in the text string. These characters are known as
_ the carriage return , ( in VBA coding this is the constant vbCr )
and
_ the line feed, ( in VBA coding this is the constant vbLf )

Most commonly, both those 2 characters are used. But sometimes, just one of those characters is used.
We need to know which character(s) are used in your text file, and we need to know if that is constantly the case.

When we know this, we can replace all combination of the tab character and the new line character(s) with nothing. That effectively removes the space and the new line, which is what you want.

One way to do this in VBA coding would be as follows:
We would use VBA to import the text file into a single string variable,
then do that replacing , ( so something like replacing vbTab & vbCr & vbLf with nothing,
then remake the text file from the modified string.


To demonstrate this VBA way, we would need a sample text file. For the demonstration we only need a text file of a few lines. ( The first thing I would do with that text file is to determine what character(s) are used for the new line, for example using my function here: https://excelfox.com/forum/showthrea...ts-of-a-string )

( I expect that another way to do this would be using Power Query. I don’t know how to do that, but someone else may be able to demonstrate that after I have determined what character(s) are used for the new line )


So, in order to help you further we need a reduced size sample text file from you



Alan