I have a large excel spreadsheet where each cell has multiple lines of text. Each cell has 2-4 lines of text. However I only want to keep the first line of text.
I want it to only be:
Better yet, I would like to cut the second line of each cell in column B and have them in column C. I am using microsoft excel 2013. Is there a way to do this?
There are almost 500 people so don't want to have to do it manually!