Ascii in a cell
 

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

Ascii in a cell
 

=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.

Mr Doggo wrote:

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

Ascii in a cell
 

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

"Dave Peterson" wrote:

=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.

Mr Doggo wrote:

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

Ascii in a cell
 

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


Gord

On Sat, 2 Sep 2006 14:51:01 -0700, Mr Doggo <Mr
wrote:

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

"Dave Peterson" wrote:

=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.

Mr Doggo wrote:

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


Gord Dibben MS Excel MVP

Ascii in a cell
 

Grrrrr.

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



Gord Dibben wrote:

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

Gord

On Sat, 2 Sep 2006 14:51:01 -0700, Mr Doggo <Mr
wrote:

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

"Dave Peterson" wrote:

=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.

Mr Doggo wrote:

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


Gord Dibben MS Excel MVP

--

Dave Peterson