• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 48
  • Last Modified:

How to only keep first line of text in each cell on excel

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.

For example

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!
hannah chan
hannah chan
  • 2
1 Solution
Prakash SamariyaIT ProfessionalCommented:
You can use Text to Column feature of excel!

Please find below example for info:
Glenn RayExcel VBA DeveloperCommented:
^Pretty cool trick.  Gonna have to add that to my knowledge-base.
Prakash SamariyaIT ProfessionalCommented:
@hannah, hope you got answers from my link! Isn't it?
@Glenn, Thank you :)
No comment has been added to this question in more than 21 days, so it is now classified as abandoned.

I have recommended this question be closed as follows:

Accept: Prakash Samariya (https:#a41801592)

If you feel this question should be closed differently, post an objection and the moderators will review all objections and close it as they feel fit. If no one objects, this question will be closed automatically the way described above.

Experts-Exchange Cleanup Volunteer
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now