I got hundreds of cells in a column with manual line breaks (Alt + Enter). I wonder whether it is possible to extract the cell contents in front of the manual line breaks using VBA code or a formula.
I have attached a sample for your convenience.
Help is much appreciated. Thank you very much in advance.