Sorting and preserving empty fields on CSV file?

I have a CSV file with about 15 fields. In most of the records the last 3-5 fields are empty so the record looks something like

Please Login or Register  to view this content.

I use Excel to sort it and split the file by dates. I use the split files on another application, but this application needs to be able to recognize that there are empty fields. Excel just gets rid of the empty fields and inserts a new line after there's no more data:

Please Login or Register  to view this content.

How can I sort the file and preserve the empty fields?

Any help will be appreciated!

Never mind!
I solved it... I put all the data on a database, did some queries and exported the data as a CSV file.

Thanks anyways!