cjj123
asked on
Excel - copy first line in a multi-line cell
I have an Excel spreadsheet with a column in it that contains multiple lines in each cell. The lines in those cells are separated by a line break (when entering data in the cell, pressed Alt + Enter to start new lines). I want to copy the first line in every one of those cells into a new cell.
Can you help?
Cell contents appear as follows:
This is line 1
This is line 2
This is line 3
I want the result to look as follows:
This is line 1
Can you help?
Cell contents appear as follows:
This is line 1
This is line 2
This is line 3
I want the result to look as follows:
This is line 1
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER