How to stop macro from treating comma as a new line character while copying for a text fil

**fblaze** · 11-25-2014, 04:32 PM

Hello,

I have written the below code to copy entire content of any .txt file into a excel sheet. Surprisingly, any comma "," found in the .txt file is being treated as a new line character while pasting in a work sheet. Could someone help me on how to stop the macro from treating a "," as a new line character?

Please Login or Register  to view this content.

**Debraj Roy** · 11-25-2014, 04:41 PM

Try this..

Please Login or Register  to view this content.

Line Input is the syntax, in case you want to delimiter as line.

**fblaze** · 11-25-2014, 05:02 PM

It worked! Thanks!

**Debraj Roy** · 11-25-2014, 05:17 PM

Thanks for the feedback..

How to stop macro from treating comma as a new line character while copying for a text fil

LinkBack

Thread Tools

Rate This Thread

Display

How to stop macro from treating comma as a new line character while copying for a text fil

Re: How to stop macro from treating comma as a new line character while copying for a text

Re: How to stop macro from treating comma as a new line character while copying for a text

Re: How to stop macro from treating comma as a new line character while copying for a text

Thread Information

Users Browsing this Thread

Similar Threads

'text to columns' or 'split' function for line of text without space, comma, etc?

[SOLVED] If comma present, then place a character before and after comma (FORMULA)

Line Graph: Treating multiple entries for the same date as a sum?

Macro to find character and delete all text in cell after the character

How do I stop Excel from treating blank cells as zero?

Bookmarks

Bookmarks

Posting Permissions