A Question about returns in Excel .csv files

 

I have attempted to answer this question myself for a long time and have been unsuccessful so now I'm going to ask about it.

When I look at a file like for instance the "Culvers" file in Fast Food or Restaurants, when I open it in Mac Excel, Column D looks across like everything is straight across. If I then copy it to another Excel Worksheet, Columns A, B, C stay the same but Column D than has a return after Street line, and after the Zip-code. When re-saved as a .csv format, the returns stay in and the whole thing has a line space for 3 lines within the same record.

If I make any sense (and I may not) I do not understand where the returns were hidden in the original record. I would like to use this but I'm lost. I guess the years of using "Appleworks: stunted my knowledge.

--
NUVI 660, Late 2012 iMac, Macbook 2.1 Fall 2008, iPhone6 , Nuvi 3790, iPad2

line feed = Char(10) = ALT-ENTER

The file has line feed after the address and zip.

The code is a CHAR(10) in Excel or use a ALT-ENTER to place the code where you want a line feed to appear. Another great way is to use ASAP addon to merge two fields with a line-feed.

Sorry I am not a MAC user but if you open the text file (CSV) in notepad or any other text editor you should see a square box representing the char(10) line feed code.

I hope this helps

--
Garmin Nüvi 650, 255WT

Excel

I'm not familiar with Mac's Excel, but Windows MS Excel default will only display the portion of column D that precedes the linefeed. Click on the data in column D and it will display all column D data in multiple lines.

RT

--
"Internet: As Yogi Berra would say, "Don't believe 90% of what you read, and verify the other half."

FYI

To see the whole text readjust the rows height and width.

--
Garmin Nüvi 650, 255WT

Yes, but ...

DRMCMTR wrote:

To see the whole text readjust the rows height and width.

Yes, but "Windows MS Excel default will only display the portion of column D that precedes the linefeed".

TY

--
"Internet: As Yogi Berra would say, "Don't believe 90% of what you read, and verify the other half."

.

To see the entire text, the word wrap attribute must be removed from the cell(s).

Highlight the cell(s) or column you want to change.

For Excel 2007, click the Home tab, then the Word Wrap icon.

For other versions of Excel, use Format, Cells, Alignment then uncheck the Wrap Text box in the Text Control section

--
Nüvi 2595LMT

Displaying data in Exxcel

WAASup wrote:

To see the entire text, the word wrap attribute must be removed from the cell(s).

Highlight the cell(s) or column you want to change.

For Excel 2007, click the Home tab, then the Word Wrap icon.

For other versions of Excel, use Format, Cells, Alignment then uncheck the Wrap Text box in the Text Control section

The easiest way to set Excel so you can see all the data as it is formatted takes 3 mouse clicks.

1. Click the unlabeled row/column indicator to the left of A and above 1 to select the entire sheet.

2. Click the separator between columns A & B (the cursor changes) and the columns will automatically size to the correct width.

3. Click the separator between rows 1 & 2 (the cursor again changes) and the row height will automatically change to display the data with embedded returns.

--
ɐ‾nsǝɹ Just one click away from the end of the Internet