add a new line on the same cell using a formula

K

karlo

Hi,

if someone could help me out, that would be great.

here's my prob. I have a database, lets say a list of notes per day fo
5 different people. im using VLOOKUP on a separate sheet so that when
track a specific person's notes and other stuff, the only data ther
would be for that person only.

I have merged cells into one big cell and used CONCATENATE as formul
to collate data. Each note from each day would be collated and this i
the desired result

DAY1: blah blah blah blah blah
DAY 2: the quick brown fox jumped over the lazy dog
DAY 3: the big bad wolf is not so bad after all.

With CONCATENTE, this is the result:

DAY1: blah blah blah blah blah DAY 2: the quick brown fox jumped ove
the lazy dog DAY 3: the big bad wolf is not so bad after all.

Take note that this should be only in one cell. Text wrap wont hel
because this would only adjust the formatting when there are a lot o
notes. I know its workable. Hope someone could help me out. Thanks.

:
 
C

count

Try this:
=A1&Chr(10)&A2&Chr(10)&A3
Ampersand can safely be used instead of Concatenate
HTH
Paul
 
R

Rodney Baker

using vbNewLine should also work instead of chr(10) - same result, it just
makes the code easier to read when you go back to it later...

Rodney.


count said:
Try this:
=A1&Chr(10)&A2&Chr(10)&A3
Ampersand can safely be used instead of Concatenate
HTH
Paul
Click to expand...
 
T

Tom Ogilvy

vbNewLine is a VBA constant.

the example is a formula in a cell where vbNewLine would be recognized as an
undefined name and the cell would return #Name

--
Regards,
Tom Ogilvy

Rodney Baker said:
using vbNewLine should also work instead of chr(10) - same result, it just
makes the code easier to read when you go back to it later...

Rodney.
Click to expand...
 
R

Rodney Baker

I stand corrected - I was thinking VBA.

Rodney.

Tom Ogilvy said:
vbNewLine is a VBA constant.

the example is a formula in a cell where vbNewLine would be recognized as an
undefined name and the cell would return #Name

--
Regards,
Tom Ogilvy

when
Click to expand...
 
K

karlo

hmmm... i already tried Chr(10) even before but it doesnt seem to work
Im using Excel 2000. would that be a problem?

Are there other workarounds
 
D

Dave Peterson

You use =char(10) in a cell on the worksheet.

chr(10) is for VBA.

=A1&Char(10)&A2&Char(10)&A3
 
Top