• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 52
  • 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
Name
job
location

I want it to only be:
Name


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

Please find below example for info:
http://datapigtechnologies.com/blog/index.php/split-data-into-several-columns-based-on-carriage-returns/comment-page-1/
0
 
Glenn RayExcel VBA DeveloperCommented:
^Pretty cool trick.  Gonna have to add that to my knowledge-base.
1
 
Prakash SamariyaIT ProfessionalCommented:
@hannah, hope you got answers from my link! Isn't it?
@Glenn, Thank you :)
0
 
frankhelkCommented:
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.

frankhelk
Experts-Exchange Cleanup Volunteer
0
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

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

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