VBA: Clean CSV line break file (concatenate based on value)

[AndersThyme]

Dear all,

I hope you can help me with a VBA code, that I need at work to clean up CSV files that contains line breaks and that are broken into multiple columns.

I need the VBA to make sure that all cells in column A starts with XXX0000-XX-000000 (where 0=any number and X=any letter) and ends with a quotation mark.
This way, I can easily split to columns, as intended.

Right now, the CSV file is already split up into multiple columns for some rows AND multiple rows (see example in attached).

I have explained what it looks like and what I need in the attached file, I hope that is okay, it is difficult to explain in free text.

Thank you in advance,

Kr Anders

[nankw83]

Can you show the expected results based on the attached sample file ?

[AndersThyme]

Yes, of course. Hereby the result attached :-)

[nankw83]

Try below code ...

Please Login or Register  to view this content.

[AndersThyme]

Hi Nankw83,

Thank you very much, the code works perfectly! :-)

It is really appreciated, and will save me so much time in the future! Have a great day.

kr Anders

[nankw83]

Glad to help & thanks for the added Rep.

Please take a moment & mark this thread as [SOLVED] from the Thread Tools menu above your first post