Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
"Cell"
How to split a cell in 2 or 3 rows (or lines). I just want to write a looooooooong addresee name and an address.
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
"Cell"
Try typing into a blank cell (without the quotes as shown):
"This is a test" <<hold down the Alt key and simultaneously press the Enter key and continue with "and this is a test line 2" << Repeat key assignment above "and a final test line 3" <<< Repeat "I can keep going, and going...." << A final enter places the text into the cell How's that? "Zoraida" wrote in message ... How to split a cell in 2 or 3 rows (or lines). I just want to write a looooooooong addresee name and an address. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
"Cell"
Zoraida
JMay's answer is right on the mark so no changes there. However, I would caution you about entering all that info in one cell. Makes it very difficult to Filter, Sort or use the names and addresses for mailmerges with other applications like Word for labels and envelopes etc. Separate cells for each part of the address allows more functionality for manipulation later. Name, Address, City, State, ZIP in five columns comes to mind. Gord Dibben Excel MVP On Sat, 21 Feb 2004 15:37:31 -0500, "JMay" wrote: Try typing into a blank cell (without the quotes as shown): "This is a test" <<hold down the Alt key and simultaneously press the Enter key and continue with "and this is a test line 2" << Repeat key assignment above "and a final test line 3" <<< Repeat "I can keep going, and going...." << A final enter places the text into the cell How's that? "Zoraida" wrote in message ... How to split a cell in 2 or 3 rows (or lines). I just want to write a looooooooong addresee name and an address. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
"Cell"
Hi there, Guys, THANK YOU VERY MUCH. It works! Anyhow, it is very important to keep in mind the second reply because I am going to use it in mail merge (labels and envelopes). Again, thanks. Zoraida *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
"CELL("FILENAME") NOT UPDATE AFTER "SAVE AS" ACTION | Excel Discussion (Misc queries) | |||
Help!!! Enter "7" in a cell and Excel changes the "7" to "11" immediately!!! | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
Complex if test program possible? If "value" "value", paste "value" in another cell? | Excel Discussion (Misc queries) |