Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 55
  • Last Modified:

import text into excel

Hello,

Need import text from my legacy system into excel.
Working fine if is no "enters" between lines. Everything is paste in one row.
Not working if "enters" exist, text is pasted into multiple rows.
Is any way to drop "enters" during paste process and get everything in one row even if source text  has "enter" spots in it ?

thanks a lot

henry
0
henryk123
Asked:
henryk123
2 Solutions
 
FarWestCommented:
are you using manual copy & paste?
0
 
NorieVBA ExpertCommented:
How are you currently importing the data into Excel?
0
 
CoSmismgrCommented:
Quick answer: No
You would have to edit the source data to remove the new line commands.
0
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
henryk123Author Commented:
Yes, I'm using copy and paste.
0
 
KnightsReignArchitectCommented:
You may want to try doing a find and replace after dates or names for example with a "comma" then you import the file in Excel as a comma delineated file.  This will separate your file and place the data into individual cells.

10-01-15, last name, first name,

Hope this helps.
0
 
FarWestCommented:
you can download notepad++ and use it to open the file, then remove Carriage Return (CR)
later you can use macro in NotePad++ to automate this task
0
 
henryk123Author Commented:
Please see attached file.

Any way to build macro and get final result ?

h.
0
 
Let's GoCommented:
No file attached?
0
 
henryk123Author Commented:
Here you go, sorry....
test.xlsx
0
 
aikimarkCommented:
are you pasting single rows at a time or multiple rows at a time?

It would be helpful if you shared a representative sample of data that doesn't paste correctly.
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

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