=CONCATENATE(A2, " ", B2, " ", C2, CHAR(10), " ", D2)

HI Chip,

This is an example of my formula and when I past the information into
another worksheet, the text doesn't show, it just says #REF!

Any ideas?

"Chip Pearson" wrote:

You can use CONCATENATE like

=CONCATENATE(A1,B1,C1)

or use the & operator:

=A1&B1&C1

What specific problems are you having?

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Terri" wrote in message
...
I am trying to combine columns and have tried the formula that
is on help,
the concatenate formula, but it doesn't seem to do anything.
What step am I
missing?