| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Concatenate with Line Feed not working
Good morning, all.
trying to combine two cells with a line feed (char(10)) and I just get the square box. Tried copying the example in EXCEL help, but still got the square box. Used both the CONCATENAT function and the ampersands. Still get the square box. ALT-ENTER works fine if I am typing text. Have tried it in the formulas, but to no avail. =CONCATENATE(MasterList!A$3,CHAR(10),MasterList!C$ 3) =MasterList!A$3 & CHAR(10) & MasterList!C$3 and =MasterList!A$3&CHAR(10)&MasterList!C$3 all return the little square. Thank you in advance -- JP Cummings |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Concatenate with Line Feed not working
EXCEL 2003. sorry
-- JP Cummings "Cummings" wrote: Good morning, all. trying to combine two cells with a line feed (char(10)) and I just get the square box. Tried copying the example in EXCEL help, but still got the square box. Used both the CONCATENAT function and the ampersands. Still get the square box. ALT-ENTER works fine if I am typing text. Have tried it in the formulas, but to no avail. =CONCATENATE(MasterList!A$3,CHAR(10),MasterList!C$ 3) =MasterList!A$3 & CHAR(10) & MasterList!C$3 and =MasterList!A$3&CHAR(10)&MasterList!C$3 all return the little square. Thank you in advance -- JP Cummings |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Concatenate with Line Feed not working
Hi, Just format the cells, Format, Cells, Alignment, Wrap Text, OK
And then the char(10) will be recognised. Peter "Cummings" wrote: EXCEL 2003. sorry -- JP Cummings "Cummings" wrote: Good morning, all. trying to combine two cells with a line feed (char(10)) and I just get the square box. Tried copying the example in EXCEL help, but still got the square box. Used both the CONCATENAT function and the ampersands. Still get the square box. ALT-ENTER works fine if I am typing text. Have tried it in the formulas, but to no avail. =CONCATENATE(MasterList!A$3,CHAR(10),MasterList!C$ 3) =MasterList!A$3 & CHAR(10) & MasterList!C$3 and =MasterList!A$3&CHAR(10)&MasterList!C$3 all return the little square. Thank you in advance -- JP Cummings |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Concatenate with Line Feed not working
ARGHH!!!!!!!!!!!!!!!!!!
Thanks. You know, sometimes it would be really nice if these things were mentioned on the program's help page. But then, you wouldn't get paid. But you don't. Thank you from the bottom of my heart for the answer to this and countless other stupid questions I've asked over the years. Jim -- JP Cummings "Billy Liddel" wrote: Hi, Just format the cells, Format, Cells, Alignment, Wrap Text, OK And then the char(10) will be recognised. Peter "Cummings" wrote: EXCEL 2003. sorry -- JP Cummings "Cummings" wrote: Good morning, all. trying to combine two cells with a line feed (char(10)) and I just get the square box. Tried copying the example in EXCEL help, but still got the square box. Used both the CONCATENAT function and the ampersands. Still get the square box. ALT-ENTER works fine if I am typing text. Have tried it in the formulas, but to no avail. =CONCATENATE(MasterList!A$3,CHAR(10),MasterList!C$ 3) =MasterList!A$3 & CHAR(10) & MasterList!C$3 and =MasterList!A$3&CHAR(10)&MasterList!C$3 all return the little square. Thank you in advance -- JP Cummings |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I insert a line feed in a formula? | Excel Worksheet Functions | |||
| Fonts & Line Feed in a Cell | Excel Discussion (Misc queries) | |||
| Replace Line Feed | Excel Discussion (Misc queries) | |||
| How to put line feed in a cell using a character not Alt/Enter | Excel Discussion (Misc queries) | |||
| How do I get rid of line feed characters in wrapped text? | Excel Discussion (Misc queries) | |||
Linear Mode
