concatenate a large number of datas (600 lines and 300k characters)

Hello everybody,
I am searching for a way to concatenate a large number of data (489 lines and 200k characters) in excel or with other tools. I am searching for a simple concatenation without adding any spacebars, commas etc. In every line there is a code that I have to merge and then include the whole thing in xml file. I found some macros online but none of them work for such a large number of characters. Could anybody suggest me a solution? Your kind help shall be appreciated.

Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Attached please find all 489 line of data that I want to concatenate.

If there would be just 2 lines of data this simple formula would do a trick: =+A1&A2

however, because there are 489 lines I am looking for the solution that is not manual.

I found some macros on the internet but they all have a limitation of cca 250 lines or 50000 characters.

Could someone direct me to a macro that is not limited or to a program that would do this job?

Your Data is 199495 Characters. Excel will only allow 32767 Characters in a Cell.

Exactly, I was thinking the same as Pete_UK.
Dump to simple txt file.

Simple macro:

Sub SaveMyData()
Dim myFile As String, i As Integer
myFile = "D:\hugeDataFile.txt" ' be sure that you have a right for this location, D is my example only
Open myFile For Output As #1
For i = 1 To 500
If (Cells(i, 1).Value <> "") Then
Print #1, trim(Cells(i, 1).Value); 'semicolon makes concatenation without carriage new line
End If
Next i
Close #1
End Sub