Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi all,
I'm having troubles to simulate the alt+enter character into a formula of excel 2003. In previous versions, I could use something like = "A" & char(10) & "B" In this version, instead of displaying A and B in the same cell, on another line, I get A (a square symbol/character) B. If I'm doing a copy/paste special (values), I have the same display. If I enter the cell using F2 and simply pressing Enter, the square character is replaced by the newline. What am I doing wrong ? Have to immediatly have the newline ! Thanks in advance ! Bart |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2003 Formula cell reference colours (colors) | Setting up and Configuration of Excel | |||
Importing data to excel (newline/carriage return issue) | Excel Discussion (Misc queries) | |||
How to substitute a comma with a newline char using Replace. | Excel Discussion (Misc queries) | |||
Excel 2003 - SUM Formula - exclude cell | Excel Worksheet Functions | |||
How do I ignore newline character/carriage return while importing | Excel Discussion (Misc queries) |