| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
add a new line on the same cell using a formula
You use =char(10) in a cell on the worksheet.
chr(10) is for VBA. =A1&Char(10)&A2&Char(10)&A3 "karlo <" wrote: hmmm... i already tried Chr(10) even before but it doesnt seem to work. Im using Excel 2000. would that be a problem? Are there other workarounds? --- Message posted from http://www.ExcelForum.com/ -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula for several IFs in 1 single line/cell ..?? | Excel Discussion (Misc queries) | |||
| How to line break in one cell via a formula to stack cell entries | Excel Worksheet Functions | |||
| formula to use next cell in line | Excel Discussion (Misc queries) | |||
| Help - every cell starts with ' r ^ in the formula line! | Excel Discussion (Misc queries) | |||
| How do I use a formula to create a new line of text in a cell? | Excel Worksheet Functions | |||
![Dave Peterson[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
