| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula and go to next line
Hello this is my formula
=Title&" "&Name&CHAR(10)&Address1&IF(Address2=0,"",CHAR(10) &Address2) I want the title and name on one line and on the next line address 1 then address 2 on the next line, if any. this formula shows everything is on ONE LINE what's wrong Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula and go to next line
You have to format cell to wrap text.
Format Menu - Cell - Alignment - Wrap text "Wanna Learn" wrote: Hello this is my formula =Title&" "&Name&CHAR(10)&Address1&IF(Address2=0,"",CHAR(10) &Address2) I want the title and name on one line and on the next line address 1 then address 2 on the next line, if any. this formula shows everything is on ONE LINE what's wrong Thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula and go to next line
Format/ Cells/ Alignment: tick Wrap text.
-- David Biddulph "Wanna Learn" wrote in message ... Hello this is my formula =Title&" "&Name&CHAR(10)&Address1&IF(Address2=0,"",CHAR(10) &Address2) I want the title and name on one line and on the next line address 1 then address 2 on the next line, if any. this formula shows everything is on ONE LINE what's wrong Thanks |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula and go to next line
David: Before posting your suggestions, look at other posting first. You
often give the same answers that have been previously posted. "David Biddulph" wrote: Format/ Cells/ Alignment: tick Wrap text. -- David Biddulph "Wanna Learn" wrote in message ... Hello this is my formula =Title&" "&Name&CHAR(10)&Address1&IF(Address2=0,"",CHAR(10) &Address2) I want the title and name on one line and on the next line address 1 then address 2 on the next line, if any. this formula shows everything is on ONE LINE what's wrong Thanks |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula and go to next line
That is a newsgroup featu there is a delay between the time you post your
message and the time when David gets to read it. So he does not know an answer has been sent. There is no harm with duplicates; even a slight difference in the way the answer is presented can make it easier for the OP to understand what to do. best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Joel" wrote in message ... David: Before posting your suggestions, look at other posting first. You often give the same answers that have been previously posted. "David Biddulph" wrote: Format/ Cells/ Alignment: tick Wrap text. -- David Biddulph "Wanna Learn" wrote in message ... Hello this is my formula =Title&" "&Name&CHAR(10)&Address1&IF(Address2=0,"",CHAR(10) &Address2) I want the title and name on one line and on the next line address 1 then address 2 on the next line, if any. this formula shows everything is on ONE LINE what's wrong Thanks |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula and go to next line
The delay is only around 5 minutes. David has responsed much much longer
than the normal 5 minute delay. "Bernard Liengme" wrote: That is a newsgroup featu there is a delay between the time you post your message and the time when David gets to read it. So he does not know an answer has been sent. There is no harm with duplicates; even a slight difference in the way the answer is presented can make it easier for the OP to understand what to do. best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Joel" wrote in message ... David: Before posting your suggestions, look at other posting first. You often give the same answers that have been previously posted. "David Biddulph" wrote: Format/ Cells/ Alignment: tick Wrap text. -- David Biddulph "Wanna Learn" wrote in message ... Hello this is my formula =Title&" "&Name&CHAR(10)&Address1&IF(Address2=0,"",CHAR(10) &Address2) I want the title and name on one line and on the next line address 1 then address 2 on the next line, if any. this formula shows everything is on ONE LINE what's wrong Thanks |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula and go to next line
You guys are great! Thank you
"Joel" wrote: You have to format cell to wrap text. Format Menu - Cell - Alignment - Wrap text "Wanna Learn" wrote: Hello this is my formula =Title&" "&Name&CHAR(10)&Address1&IF(Address2=0,"",CHAR(10) &Address2) I want the title and name on one line and on the next line address 1 then address 2 on the next line, if any. this formula shows everything is on ONE LINE what's wrong Thanks |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula and go to next line
Lots of people retrieve the new headers all at once. Then they work their way
down those new messages. The delay between retrieving the headers, getting to that message, then posting a response, can be much more than 5 minutes. Joel wrote: The delay is only around 5 minutes. David has responsed much much longer than the normal 5 minute delay. "Bernard Liengme" wrote: That is a newsgroup featu there is a delay between the time you post your message and the time when David gets to read it. So he does not know an answer has been sent. There is no harm with duplicates; even a slight difference in the way the answer is presented can make it easier for the OP to understand what to do. best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Joel" wrote in message ... David: Before posting your suggestions, look at other posting first. You often give the same answers that have been previously posted. "David Biddulph" wrote: Format/ Cells/ Alignment: tick Wrap text. -- David Biddulph "Wanna Learn" wrote in message ... Hello this is my formula =Title&" "&Name&CHAR(10)&Address1&IF(Address2=0,"",CHAR(10) &Address2) I want the title and name on one line and on the next line address 1 then address 2 on the next line, if any. this formula shows everything is on ONE LINE what's wrong Thanks -- Dave Peterson |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula and go to next line
And multiple duplicated answers create a problem for you
because.....................? Gord Dibben MS Excel MVP On Tue, 22 May 2007 06:00:01 -0700, Joel wrote: David: Before posting your suggestions, look at other posting first. You often give the same answers that have been previously posted. "David Biddulph" wrote: Format/ Cells/ Alignment: tick Wrap text. -- David Biddulph "Wanna Learn" wrote in message ... Hello this is my formula =Title&" "&Name&CHAR(10)&Address1&IF(Address2=0,"",CHAR(10) &Address2) I want the title and name on one line and on the next line address 1 then address 2 on the next line, if any. this formula shows everything is on ONE LINE what's wrong Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding {} in the formula line | Excel Discussion (Misc queries) | |||
| Is it possible to do it by a single-line formula(without using VBA)? | Excel Discussion (Misc queries) | |||
| too deep formula line | Excel Discussion (Misc queries) | |||
| can put comment in formula line? | Excel Discussion (Misc queries) | |||
| Formula Every 3 Line | Excel Discussion (Misc queries) | |||
Linear Mode
