💻 Software

Import data into excel that doesn't use a line break as a row delimiter?

Fresh5 days ago

Mar 15, 202629334 views

Confidence Score0%

Problem

Is there any simple method that doesn't resort to macros whereby a plain text file or string can be imported into excel without using a line break as a row delimiter? Example A string in this format, and with approximately one million rows and 20 columns is being returned by an application. I need …

Error Output

11,12,13;21,22,23;31,32,33

Unverified for your environment

Select your OS to check compatibility.

Your OS

OS version

Product version

1 Fix

Canonical Fix

Unverified Fix

New Fix – Awaiting Verification

Fix for: Import data into excel that doesn't use a line break as a row delimiter?

Low Risk

Use Microsoft Word as per your solution 2, it's probably already in your business users PC. The newline is indicated as ^l. See also http://support.microsoft.com/kb/95474/en-us

Awaiting Verification

Be the first to verify this fix

Import data into excel that doesn't use a line break as a row delimiter?

Problem

Error Output

1 Fix

Fix for: Import data into excel that doesn't use a line break as a row delimiter?

Environment