Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using concatenate to include a line return
I have a string of text in one cell and another string in a different cell.
I'd like to use the concatenate worksheet function to have them in a single cell seperate by a line return. This then repeats down the columns. e.g. A B C (what I'd like) 1 ABC DEF ABC DEF 2 GHI JKL GHI JKL Does anyone know how I can insert a line return "character / symbol" into the concatenate worksheet function to make this work or alternatively can anyone suggest another way of doing this??? Thanks in advance all you lovely people.... |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using concatenate to include a line return
CHAR(10) is the symbol for the in-cell Carraige Return.
=A1&CHAR(10)&B1 will return the concatenated values of A1 and B1 in a single line, separated by a little square symbol. If you then re-format the cell, Right-click FormatCells AlignmentTab check the WrapText box, then the in-cell Carraige Returns will take affect and the row will automatically resize. hth Vaya con Dios, Chuck, CABGx3 "dan" wrote: I have a string of text in one cell and another string in a different cell. I'd like to use the concatenate worksheet function to have them in a single cell seperate by a line return. This then repeats down the columns. e.g. A B C (what I'd like) 1 ABC DEF ABC DEF 2 GHI JKL GHI JKL Does anyone know how I can insert a line return "character / symbol" into the concatenate worksheet function to make this work or alternatively can anyone suggest another way of doing this??? Thanks in advance all you lovely people.... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I hit return but stay in the same cell to enter a new line | Excel Discussion (Misc queries) | |||
Can I link timeline labels to a line chart? | Charts and Charting in Excel | |||
How to add a vertical line to a Line Chart that aleady has 2 Y axi | Charts and Charting in Excel | |||
strange horizontal line showing accross several columns | Excel Discussion (Misc queries) | |||
pivot table multi line chart | Charts and Charting in Excel |