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?

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?

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?

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

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?