Help cleaning up text download

shdwfx

New member
Joined
May 2, 2016
Messages
1
Reaction score
0
Points
0
Not even sure where to start with this but here goes...... Attached is a file of text downloaded from our system. It contains texts which could be one line, could be multiple lines. Unfortunately, it has the material number on only the first line and the lines are not numbered to allow for sorting. I've got the 'before' and the 'after' in the attachment. Any help with formulas (I don't know VBA) is greatly appreciated.
 

Attachments

  • SALES TEXTS EXAMPLE 05022016.xlsx
    11.3 KB · Views: 7
Copy without empty rows

Any help with formulas (I don't know VBA) is greatly appreciated.
See if can you help this solution.
Note: There have five formulas that I colored
Did it work?
 

Attachments

  • shdwfx-navic.xlsx
    13.1 KB · Views: 0
Back
Top