Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Alt Enter in a cell
Is there a way to account for a line space (alt enter) in an excel formula?
For instance if there are three cells (ie...address, city, and state), is it possible to concatenate them, but after the address the function inserts an alt enter so it moves down a line space and then have the city and state under the address all in one cell? So basically is there a way to tell a formula that it needs to alt enter without having to do it manually? |
#2
|
|||
|
|||
=A1&CHAR(10)&B1&CHAR(10)&C1
and make sure wrap text is set -- HTH RP (remove nothere from the email address if mailing direct) "JJ" wrote in message ... Is there a way to account for a line space (alt enter) in an excel formula? For instance if there are three cells (ie...address, city, and state), is it possible to concatenate them, but after the address the function inserts an alt enter so it moves down a line space and then have the city and state under the address all in one cell? So basically is there a way to tell a formula that it needs to alt enter without having to do it manually? |
#3
|
|||
|
|||
Assuming cols A to C contain the text to be concat,
from row1 down With col D formatted to wrap text (this is required): Put in D1: =A1&CHAR(10)&B1&CHAR(10)&C1 Copy D1 down -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- "JJ" wrote in message ... Is there a way to account for a line space (alt enter) in an excel formula? For instance if there are three cells (ie...address, city, and state), is it possible to concatenate them, but after the address the function inserts an alt enter so it moves down a line space and then have the city and state under the address all in one cell? So basically is there a way to tell a formula that it needs to alt enter without having to do it manually? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting | Excel Discussion (Misc queries) | |||
enter value in a cell from a combo box | Excel Discussion (Misc queries) | |||
How do i enter a note in excel to an unlocked cell on a protected. | Excel Discussion (Misc queries) | |||
Enter every nth cell item | Excel Discussion (Misc queries) | |||
Can you enter a formula in a cell that auto-inputs calculations a. | Excel Worksheet Functions |