View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Chip Pearson
 
Posts: n/a
Default Need help with concatenate formula

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?