Need help with concatenate formula

T

Terri

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

Chip Pearson

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
 
B

Biff

Hi!

Kind of sparse on details, aren't you?

A1 = try_
B1 = this

=A1&B1

Returns: try_this

Biff
 
T

Terri

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

Terri

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!
 
Top