Excel 2000 concatenate 1

[brunei]

definition of variables:
a2 = cell formatted as text
b2 = cell formatted as text
c2 = cell formatted as text
d2 = cell formatted as general

If I try to =concatenate(a2,b2) into c2; the concatenate formula appears in the cell

However, if I try to =concatenate(a2,b2) into d2; the function works properly and the information is displayed

Is there a reason for this?

 

[Dreamboat]

Sure, you can't put a formula in a column formatted as text. Select the column, hit Edit-Clear-All to get rid of all formatting, save the file. This should reset column C as general formatting. The concatenation formula always returns a string (text) anyway.

techsupportgirl@home.com
Brainbench MVP for Microsoft Word

http://www.brainbench.com