I have a few columns (~75000 rows) where I've extracted data and included HTML tags. I've removed the tags, but now there are line breaks I'm hoping I can eliminate via VBA or formula.
Column I (Current) | Column J (Final state) | |
, , Navigate to the Instructions section in page , , | Navigate to the Instructions section in page | |
| Click on the drop down and select option | |
| Spinning wheel appears and once loading is complete ensure user can see the products that were available in cart sorted by their associated ID | |
| Validate each order line number displays a PO Line number Text ID | |
| Enter number in the Number field. Update Created on date and press execute |