How do I create a line break in an Excel cell
Sun, 11/18/2007 - 12:12am
 16 years
|
I was looking at some POI files using Microsoft Excel. The cells in column D had addresses entered. The address was displayed in the cell as:
4503 Riverview Pkwy.
Birmingham, AL 35242
205-980-1016
The cell was formated for word wrap but changing the width of the cell did not change the way the address was displayed.
My question is how was this done. How do you put text on separate lines in a single cell? It's probably simple to do but in Excel it's not always obvious.
Thanks
.
Alt-Enter
Line Break
Thank you
nuvi 350/360
How do you put text on separate lines in a single cell? It's probably simple to do but in Excel it's not always obvious.
Please be aware that alt-Enter does not display as a linebreak if using a nuvi 350 and nuvi 360. The LF/CR need to be changed to <br>.
More info can be found at:
http://www.poi-factory.com/node/1486
or POI Verifier
RT
"Internet: As Yogi Berra would say, "Don't believe 90% of what you read, and verify the other half."
Excel 'concatenate'
This is what I do with my POIs and seem to work on Nuvi 370. I normally have all the fields in their own column, such as lon, lat, name, Address, City, State, Zip, Phone. Using Excel, I would use the 'Concatenate' function to combine the last column. If your columns are from A to H from the fields, then your function would be as follows:
=CONCATENATE(D1,"<*br>","city",", ",F1, G1,"<*br>",H1)
This will displays as follows on your custom poi
Name
Address
City, State Zip
Phone
Can't seem to make the <*br> to display the tag properly.
You can even add additional comments and inserting
the '<*br>' as you need it. Haven't counted the maximum characters per line though.
nuvi 2460LMT
.
This is what I do with my POIs and seem to work on Nuvi 370... Can't seem to make the <*br> to display the tag properly.
You can even add additional comments and inserting
the '<*br>' as you need it. Haven't counted the maximum characters per line though.
You meant <br> didn't you?
The maximum no. of characters in the Description field of a Nüvi 3xx is about 150. (and even though it's non-printing, <br> counts as 4!).
Note, I said "Description field" - you're not actually targeting the dedicated fields that are set aside for the Address - when you do, the heading "Contact" will appear. These fields are only accessible using .gpx input.
The latest version of GeePeeEx Editor can accept multi-column .csv files, so that you can direct a column to the gpx field of your choice.
------------------------ Phil Hornby, Stockport, England ---------------------- http://GeePeeEx.com - Garmin POI Creation made easy »
Couple tips
You can even add additional comments and inserting
the '<*br>' as you need it.
Tip 1: If you want to display <br> without the confusing (and incorrect) extra characters, just type <br> where you want the <br> to display.
Tip 2: When creating a Custom POI file for the nuvi 350 and 360, it's best to create it with the standard alt-Enter with Excel (or just Enter when using a text editor, i.e. Notepad) as most units accept this form of linebreak. Then you can use POI Verifier to automatically convert all of these standard linebreaks to <br> for use in the nuvi 350/360. So much simpler! And the plus is your Custom POI file will be compatible with other GPS units.
RT
"Internet: As Yogi Berra would say, "Don't believe 90% of what you read, and verify the other half."