Concatenate Problem

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
 
F

Frank Kabel

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