| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Insert manual line break in formula
Hi I have a formula which combines texts from several sources. Eg: ="I am a "&A30&". You are a "&A31&". However we don't "&A32&", nor "&A33&". Except that, we do "&A34&"." However the whole statement will appear in 1 line. I would like to break it into 3 lines in that cell. How to do? -- Additional information: - I'm using Office XP - I'm using Windows XP |
|
#2
|
|||
|
|||
|
Hi
Format the cell FormatCellAlignmentWrap text Insert Char(10) within your formula where you want a new line. e.g. ="I am a "&A30& char(10)&" You are a "&A31& char(10)&" We are "&A34 0-0 Wai Wai ^-^ wrote: Hi I have a formula which combines texts from several sources. Eg: ="I am a "&A30&". You are a "&A31&". However we don't "&A32&", nor "&A33&". Except that, we do "&A34&"." However the whole statement will appear in 1 line. I would like to break it into 3 lines in that cell. How to do? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automatically insert row and copy formula | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| if formula = negative #, then insert a word | Excel Worksheet Functions | |||
| Challenging Charting | Charts and Charting in Excel | |||
| How to insert a complex formula in a cell with VBA | Excel Worksheet Functions | |||
Linear Mode
