D
DRARetired
How can I put a newline command in a cell formula? I've
tried using Alt-Enter, but it doesn't work.
tried using Alt-Enter, but it doesn't work.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Doug Kanter
Why would you want to wrap a formula? Do you mean text, or an actual
formula?
formula?
D
David McRitchie
In a Worksheet use CHAR(10)
in a macro use CHR(10)
Alt+Enter automatically turns on Cell Wrap. This won't
so you may have to format the cells yourself.
Format, cells, Alignment (tab), turn on wrap cells
in a macro use CHR(10)
Alt+Enter automatically turns on Cell Wrap. This won't
so you may have to format the cells yourself.
Format, cells, Alignment (tab), turn on wrap cells
D
draretired
The text display of a formula.
my formula is:
=TEXT(Calendar+(ROW(D2)-ROW(Calendar))*7/2+(COLUMN(D2)-
COLUMN(Calendar)),"d")& NEWLINE OFFSET(List!$C$1,(ROW(D2)-
ROW(Calendar))*7/2+(COLUMN(D2)-COLUMN(Calendar)),0)
The the first line is a date and otherlines are text.
Thanks,
Don
my formula is:
=TEXT(Calendar+(ROW(D2)-ROW(Calendar))*7/2+(COLUMN(D2)-
COLUMN(Calendar)),"d")& NEWLINE OFFSET(List!$C$1,(ROW(D2)-
ROW(Calendar))*7/2+(COLUMN(D2)-COLUMN(Calendar)),0)
The the first line is a date and otherlines are text.
Thanks,
Don
G
Guest
The char(10) worked.
Thanks,
Don
Thanks,
Don
-----Original Message-----
In a Worksheet use CHAR(10)
in a macro use CHR(10)
Alt+Enter automatically turns on Cell Wrap. This won't
so you may have to format the cells yourself.
Format, cells, Alignment (tab), turn on wrap cells
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
How can I put a newline command in a cell formula? I've
tried using Alt-Enter, but it doesn't work.
.