|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
September 17th, 2003, 06:00 PM
|
|||
|
|||
return in excel
i have a cell in a spreadsheet, which i was currently
displaying the values of two other cells, with a space between the values. what i would like would be to have both values being on seperate lines, within the same cell. how do i do this? thanks, Christian K. 
|
|
#2
September 17th, 2003, 06:57 PM
|
|||
|
|||
|
return in excel
F2 to edit. Hit Alt-Enter between the two values.
HTH Paul -------------------------------------------------------------------------------------------------------------- Be advised to back up your WorkBook before attempting to make changes. -------------------------------------------------------------------------------------------------------------- On Wed, 17 Sep 2003 10:00:00 -0700, "Christian" wrote: i have a cell in a spreadsheet, which i was currently displaying the values of two other cells, with a space between the values. what i would like would be to have both values being on seperate lines, within the same cell. how do i do this? thanks, Christian K.
|
|
#3
September 17th, 2003, 06:58 PM
|
|||
|
|||
|
return in excel
Christian,
In A1, "Hello" In B1, "there" In C1, =A1&CHAR(10)&B1 Note: Format C1 for WrapText John Christian wrote: i have a cell in a spreadsheet, which i was currently displaying the values of two other cells, with a space between the values. what i would like would be to have both values being on seperate lines, within the same cell. how do i do this? thanks, Christian K.
|
|
#4
September 17th, 2003, 07:15 PM
|
|||
|
|||
|
return in excel
alt enter at the point you want separation
"Christian" wrote in message ... i have a cell in a spreadsheet, which i was currently displaying the values of two other cells, with a space between the values. what i would like would be to have both values being on seperate lines, within the same cell. how do i do this? thanks, Christian K.
|
|
#5
September 18th, 2003, 01:45 AM
|
|||
|
|||
|
return in excel
Christian
="a" & char(10) & "b". You will probably have to format the cell to wrap text. Tony -----Original Message----- i have a cell in a spreadsheet, which i was currently displaying the values of two other cells, with a space between the values. what i would like would be to have both values being on seperate lines, within the same cell. how do i do this? thanks, Christian K. .
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
