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

excel question about removing two line text in one cell

I am trying to prepare data for a data base by formating tthe text to culumns. However, the second line in the same cell dissapears after I do the first, of what will be a few, text to column arrangements. Th clumn in queston is "F"


Blake 201004test.xlsx
1 Solution
I think the problem is that each line contains a line delimiter, which the t-2-c wizard is splitting then possibly throwing away the second line.

One solution is to fix those lines like this:

Insert a new blank column before F (pushing F into column G) and put this formula in F2:

=LEFT(G2,FIND(CHAR(10),G2&CHAR(10))-1) & " / " & MID(G2,FIND(CHAR(10),G2&CHAR(10))+1,999)

Copy that down and now those newlines will be replaced with slashes on a single line.

Copy column F, paste back as Value and delete column G.
wagamama123Author Commented:
great job
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

Train for your Pen Testing Engineer Certification

Enroll today in this bundle of courses to gain experience in the logistics of pen testing, Linux fundamentals, vulnerability assessments, detecting live systems, and more! This series, valued at $3,000, is free for Premium members, Team Accounts, and Qualified Experts.

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