Concatenate Problem

  • Thread starter Thread starter ChuckW
  • Start date Start date
C

ChuckW

Hi,

I frequently have problems concatenating cells in Excel.
I have three columns of data that I want to concatenate.
I click on the Fx key and select function. In the first
cell in the wizard, I select C2, in the next cell I
select D2 and in the third I select E2. When I click ok,
the cell reads =CONCATENATE(C2,D2,E2) rather than
actually concatenating the data in the three rows.
Sometimes Excel will concatenate other times it will
simply give me my formula. Can anyone help?

Thanks,

Chuck
 
Hi
check the format of this cell. It is probably 'Text'. change this to
'General' and re-enter the formula
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

CONCATENATE error? 4
concatenate 5
How to CONCATENATE >50 fields in Excel table into SQL Insert State 3
Excel Concatenate with line breaks but ignore blank cells 3
Duplicate "Drag" feature 2
Concatenate Function will not work 4
Color within Concatenate 2
Fixed length string of text 7

Back
Top