Ascii in a cell

[Guest]

Hie team:

I need to know if is possible that in a cell we can use ascii character or
commands. imean, in a cell i want to merger to cells but that appear in every
single line inside the cell

cell a1 = hi
cell b1 = there
cell c1 = ="a1" & (what need i use in order to put enter here) & "b1"

i want to in cell c1 appear:
hi
there
if possible ?

regards

 

[Dave Peterson]

=a1&char(10)&b1

remember to format|Cells|alignment tab|wraptext
or you'll see a little square box.

=char(10) is the same as alt-enter if you were typing.

 

[Guest]

you are a monster dave!!!
thax a lot. (y)

=a1&char(10)&b1

remember to format|Cells|alignment tab|wraptext
or you'll see a little square box.

=char(10) is the same as alt-enter if you were typing.

 

[Gord Dibben]

We have known that for a while, but this is the first time I've seen it in
print<g>


Gord

you are a monster dave!!!
thax a lot. (y)

Gord Dibben MS Excel MVP

 

[Dave Peterson]

Grrrrr.

http://www.badmovies.org/movies/monster/monster4.jpg