Text to Columns Carriage Return Delimited

No replies
Sun, 05/30/2010 - 19:34
Tech-Karma
Tech-Karma's picture
User offline. Last seen 6 weeks 5 days ago. Offline
Karma Moderator
Joined: 09/17/2009
Posts: 204

Are you looking to import a text file delimited by carriage returns into an Excel spreadsheet?

Try the following during the import wizard:

  1. Select Delimited.
  2. Select delimited by Other and enter 0010 on the numeric keypad while holding the ALT key.

Note:  If 0010 doesn't work, you may also want to try 0013.

 

Top