Exporting MS Excel file to text file (like sample shown)

I need to take an Excel spreadsheet like the one on the left (supplied by my customer) and export/save it to a text (or MS Word) file like the one shown on the right. Any blank cells in Excel will need to show up as blank lines on the text file.

Constraints: Our order template for our customer is set up like the Excel file shown and we do not want to change it if at all possible. We can not manually edit data since some customer files contain literally thousands of lines of text (we'd also run the risk of accidently changing some lines while manually editing).

I've tried just about everything I know, and I have no knowledge of macros.

Can anybody give me direction?

Thanks,

JBeez

Changed attachment from a jpeg to a .pdf

Any help would be appreciated.

Thanks,

JBeez

Save the Excel file as TEXT Tab Delimited. This can be opened in Word.

When in Word, replace the tabs with paragraph marks.

Turn on Wildcards

In Find and Replace, enter in the Find what: ^t{2,200}

In the Replace with field enter ^p

Replace All
Turn off Wildcards

Find What: ^t
Replace With: ^p

Replace All

Find What: ^p^P

Replace With: ^p
Replace All....repeat until the result is 0 replacements.