• 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
[Webinar] Improve your customer journey

A positive customer journey is important in attracting and retaining business. To improve this experience, you can use Google Maps APIs to increase checkout conversions, boost user engagement, and optimize order fulfillment. Learn how in this webinar presented by Dito.

 
henryk123Author Commented:
Yes, I'm using copy and paste.
0
 
KnightsReignCommented:
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

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

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