| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
CHAR(10) = ALT+ENTER??
A1: The Olympics
B1: 2008 C1: =A1&CHAR(10)&B1 I expect the result in C1 to be The Olympics 2008 But, I have The Olympics 2008 I don't get the ALT+ENTER effect using CHAR(10) for line feed. What have I missed? Thanks. Epinn |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| set tab or enter keys to automatically move to different cells | Excel Discussion (Misc queries) | |||
| Cell Selection after "Enter" | Excel Discussion (Misc queries) | |||
| how to enter numbers value for calculation? | Excel Worksheet Functions | |||
| FIXED 2 DECIMAL PLACES, MUST ENTER ALL ZEROES AFTER DECIMAL POINT. | Excel Discussion (Misc queries) | |||
| Enter last name, auto fill full name & address--HOW? | Excel Discussion (Misc queries) | |||
Threaded Mode
