| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Join 2 cells with carriage return in between
Hi Need to do the following. Have C1 = A1&B1 but required to have C1 display as 2 lines A1 B1 i.e. as if Alt-Enter had been used in cell. Have tried using alt-010 in middle of A1&B1 formula. How can I get alt-enter into the formula? Thanks for any help Regards Max -- MaxBrit ------------------------------------------------------------------------ MaxBrit's Profile: http://www.excelforum.com/member.php...fo&userid=7465 View this thread: http://www.excelforum.com/showthread...hreadid=500553 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Join 2 cells with carriage return in between
in C1: =A1&CHAR(10)&B1
and format C1 with word wrap! Regards, Stefi €˛MaxBrit€¯ ezt Ć*rta: Hi Need to do the following. Have C1 = A1&B1 but required to have C1 display as 2 lines A1 B1 i.e. as if Alt-Enter had been used in cell. Have tried using alt-010 in middle of A1&B1 formula. How can I get alt-enter into the formula? Thanks for any help Regards Max -- MaxBrit ------------------------------------------------------------------------ MaxBrit's Profile: http://www.excelforum.com/member.php...fo&userid=7465 View this thread: http://www.excelforum.com/showthread...hreadid=500553 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Join 2 cells with carriage return in between
Stefi Many thanks for reply. Max -- MaxBrit ------------------------------------------------------------------------ MaxBrit's Profile: http://www.excelforum.com/member.php...fo&userid=7465 View this thread: http://www.excelforum.com/showthread...hreadid=500553 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| using the fill handle All the cells return the value of the first | Excel Worksheet Functions | |||
| Text to columns delimited by carriage return | Excel Worksheet Functions | |||
| How do I format cells in excel to allow me to hit return key ? | New Users to Excel | |||
| How do I return the highest value in a range of cells | Excel Worksheet Functions | |||
| Return non-zero cells in column | Excel Worksheet Functions | |||
Linear Mode
