.txt to xcel conversion

Hi, Hoping to get some help in figuring out how to import a text file with 10K records in excel. The problem I am having is 1 record in the text file is split in 2 rows and when imported to excel generates the following layout :-
1 3 4 5 -
5 7 10

What I am looking to do is search for "-" which is where the record splits in 2 rows and move the values of row 2 to cells in the first row after "-", while leaving "-" where it is and delete the second row.

The code would need to loop thru the entire file.

Thanks
N

Hi, Sorry didn't realize the way I had formatted the sample, it didn't display the same way. I have attached a sample this time.
You will notice the cell values are random and can at time skip cells as well.

Thanks

Thanks again for your prompt response. I have tried your solution and it seems to be combining the cell values.
In the updated attachment, below your solution I have also indicated what I am trying to do.

Thanks
N

Assuming txt file is Tab demilited.

Thanks Jindon, unless I am not doing something right - It seems like everything is being imported with the entire record in 1 cell.
Thanks
N

Hi Jindon, I took a deeper dive in the raw data that is being imported and looks like the last character is not always "-" as I originally indicated. So the solution I am looking for now is to take row 2 and merge is to row 1 in the next available cell in row 1. Attached is a sample.

Thanks
N

Can you upload txt file to be converted?

Attached is a sample in text format.

Thanks

And how do you want the result ?

After the file is imported in excel, concatenate row 2 to row 1, then row 4 to row 3 and so on.

Try this one

Please Login or Register  to view this content.

Thanks Jindon, worked perfectly. Thank you!!