Andreas Hermle
asked on
Formula to extract cell contents in front of manual line break
Dear Experts:
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.
Regards, Andreas
Formula-Extracting-Text-Before-M.xlsx
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.
Regards, Andreas
Formula-Extracting-Text-Before-M.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Dear rorya:
I sure love this forum. Thank you very much for your swift and professional support.
Regards, Andreas
I sure love this forum. Thank you very much for your swift and professional support.
Regards, Andreas
Andreas,
You are most welcome. It is always a pleasure to deal with you :)
Rory
You are most welcome. It is always a pleasure to deal with you :)
Rory
for example