HI,
I am good at Excel and formulas. I have referred the image and excel file. You are trying to remove the text every next line and also, add $ symbol, in between?
I can complete the task in 3 hours.
I can work on this and provide the solution. Preferably using vba, as the text must be splitted first with the line break and then do the necessary steps as required.
-Chandra