row separation in text file import

**mkang** · 08-31-2010, 02:38 PM

Hi everyone,
I have imported a tab delimited text file into excel. One of the columns consists of a string of text - a comment section. Within this column, there are periods and for some reason it seems that Excel is treating these periods as row separators. Does anyone know how I can prevent Excel from separating the text into rows?
Thanks in advance for any insights.
mkang

**TMS** · 08-31-2010, 04:11 PM

It may not be the periods causing the new line. There may be non-printable characters, for example, carriage return and/or line feed.

Might be worth posting a sample of the text file if it's not sensitive data.

Regards

**BartoszOrlowski1337** · 08-23-2013, 08:02 AM

Can they be omitted during import? Say I have a file that contains CR, when I open it in excel it normally splits the data in 2 rows (incorrectly).
I'm automating the import with VBA :

...

Please Login or Register  to view this content.

...

Is there a way to modify this query to not contain any non-printable characters ?

Thanks in advance!!!

**arlu1201** · 08-23-2013, 08:23 AM

Welcome to the forum, 2 pointers -

1. I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. In order to put code tags, either type [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] at the end of it, OR you can highlight your code and click the # icon at the top of your post window.

2. Unfortunately you need to post your question in a new thread, it's against the forum rules to post a question in the thread of another user. If you create your own thread, any advice will be tailored to your situation so you should include a description of what you've done and are trying to do. Also, if you feel that this thread is particularly relevant to what you are trying to do, you can surely include a link to it in your new thread.