Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Concaenate formula- text diff lines?
Is there a way to make the CONCATENATE formula put all the text on different
lines? It keeps combining some on the same lines and I want them all on separate- like a list. Thank you for your help!! LJoe |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Concaenate formula- text diff lines?
Not sure exactly what you are asking, but to concatenate 2 lines is simply,
=concatenate(a1,b1) Give us an example of what you are asking "LJoe" wrote: Is there a way to make the CONCATENATE formula put all the text on different lines? It keeps combining some on the same lines and I want them all on separate- like a list. Thank you for your help!! LJoe |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Concaenate formula- text diff lines?
right click on the cell your CONCATENATE function resides in, click Format cell, Alignment tab, under text control check Wrap text then Ok. hopefully you will get what you want. LJoe Wrote: Is there a way to make the CONCATENATE formula put all the text on different lines? It keeps combining some on the same lines and I want them all on separate- like a list. Thank you for your help!! LJoe -- starguy ------------------------------------------------------------------------ starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434 View this thread: http://www.excelforum.com/showthread...hreadid=563718 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Concaenate formula- text diff lines?
"LJoe" wrote in message
... Is there a way to make the CONCATENATE formula put all the text on different lines? It keeps combining some on the same lines and I want them all on separate- like a list. Thank you for your help!! =A1&CHAR(10)&B1 or =CONCATENATE(A1,CHAR(10),B1) You'll also need: Format/ Cells/ Alignment/ Wrap text -- David Biddulph |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Concaenate formula- text diff lines?
I am combining a3 to a10 with the formula. That is doing what I want it to
do, but I want it to appear in the cell as: a3 a4 a5...etc like a list. Right now, I have a3 to a10 all aligned left and all underneath eachother before I do the concatenate formula. I want it to look like it does now, just all in one cell. Does that clarify? "havocdragon" wrote: Not sure exactly what you are asking, but to concatenate 2 lines is simply, =concatenate(a1,b1) Give us an example of what you are asking "LJoe" wrote: Is there a way to make the CONCATENATE formula put all the text on different lines? It keeps combining some on the same lines and I want them all on separate- like a list. Thank you for your help!! LJoe |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Concatenate formula- text diff lines?
"LJoe" wrote in message
... Is there a way to make the CONCATENATE formula put all the text on different lines? It keeps combining some on the same lines and I want them all on separate- like a list. Thank you for your help!! LJoe "Wrap Text" may work, but if you include CHAR(10) between lines, it will put the right stuff on separate lines, e.g. =CONCATENATE(A1,CHAR(10),A2,CHAR(10),A3,CHAR(10),A 4) The CHAR(10) is a line feed code... Beege |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Concaenate formula- text diff lines?
Thank you so much, works great!
"David Biddulph" wrote: "LJoe" wrote in message ... Is there a way to make the CONCATENATE formula put all the text on different lines? It keeps combining some on the same lines and I want them all on separate- like a list. Thank you for your help!! =A1&CHAR(10)&B1 or =CONCATENATE(A1,CHAR(10),B1) You'll also need: Format/ Cells/ Alignment/ Wrap text -- David Biddulph |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Concatenate formula- text diff lines?
Thank you Beege. It is just what I wanted.
"Beege" wrote: "LJoe" wrote in message ... Is there a way to make the CONCATENATE formula put all the text on different lines? It keeps combining some on the same lines and I want them all on separate- like a list. Thank you for your help!! LJoe "Wrap Text" may work, but if you include CHAR(10) between lines, it will put the right stuff on separate lines, e.g. =CONCATENATE(A1,CHAR(10),A2,CHAR(10),A3,CHAR(10),A 4) The CHAR(10) is a line feed code... Beege |
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Concatenate formula- text diff lines?
Help! I have tried this formula and the items appear on one line with an =
sign between the date "LJoe" wrote: Thank you Beege. It is just what I wanted. "Beege" wrote: "LJoe" wrote in message ... Is there a way to make the CONCATENATE formula put all the text on different lines? It keeps combining some on the same lines and I want them all on separate- like a list. Thank you for your help!! LJoe "Wrap Text" may work, but if you include CHAR(10) between lines, it will put the right stuff on separate lines, e.g. =CONCATENATE(A1,CHAR(10),A2,CHAR(10),A3,CHAR(10),A 4) The CHAR(10) is a line feed code... Beege |
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Concatenate formula- text diff lines?
Rita
What date? Show us a sample of your data and the formula you are using. Gord Dibben MS Excel MVP On Tue, 12 Jun 2007 17:37:02 -0700, Rita wrote: Help! I have tried this formula and the items appear on one line with an = sign between the date "LJoe" wrote: Thank you Beege. It is just what I wanted. "Beege" wrote: "LJoe" wrote in message ... Is there a way to make the CONCATENATE formula put all the text on different lines? It keeps combining some on the same lines and I want them all on separate- like a list. Thank you for your help!! LJoe "Wrap Text" may work, but if you include CHAR(10) between lines, it will put the right stuff on separate lines, e.g. =CONCATENATE(A1,CHAR(10),A2,CHAR(10),A3,CHAR(10),A 4) The CHAR(10) is a line feed code... Beege |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
conditional formula: sum a range if text present in another range | Excel Discussion (Misc queries) | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Using the text from a cell as a range name in a formula | Excel Discussion (Misc queries) | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions |