up vote 0 down vote favorite
share [g+] share [fb]

I am trying to find a way to properly import a text file into excel that contains a carriage return using the Get External Data option.

The file has a text qualifier and is pipe delimited. Here is some example data.

"1"|"test data" 
"2"|"test data 
with a line break"

It should import 2 rows with a line break in row 2 column 2. However, it ends importing it as 3 rows.

I tried playing with the File origin settings to see if the different encodings made a difference but they do not.

link|improve this question
1  
It's a shame this got migrated from stackoverflow, because I think the only answer to this is a VBA program. – Jean-François Corbett Jul 11 '11 at 20:29
Just because the only answer is programming in VB, doesn't mean that its a programming problem. The question was asked in such a way that a non-programming solution would be more acceptable if one exists. – Justin Dearing Jul 11 '11 at 21:11
feedback

migrated from stackoverflow.com Jul 11 '11 at 19:47

This question came from our site for professional and enthusiast programmers.

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
or
required, but never shown
discard