Hi, I posted again with more details, but here is the formula I was trying:

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

and when I copied the data onto a new worksheet, it came out as #REF! The
column was wide enough though, so I must be doing something wrong with my
formula.

Thanks for any help you can give me!

"Biff" wrote:

Hi!

Kind of sparse on details, aren't you?

A1 = try_
B1 = this

=A1&B1

Returns: try_this

Biff

"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?