Concatenate strings

1

I would like to concatenate two columns of strings into one string in a separate column as follows.

A          B          C
CIK:     007924     CIK:007924
CIK:     009732     CIK:009732

but what happens is 

A          B          C
CIK:     007924     =A1&B1
CIK:     009732     =A1&B1

It does not evaluate. I have tried:

=A1+B1
="A1"+"B1"
=CONCATENATE(A6,B6)

Which all do not evaluate. They just display these formulas as is.

Deborah Weissner

Posted 2016-03-10T22:18:34.103

Reputation: 11

1Probably number formatting is set to "text" in that column. Set it to general, then re-enter the formula. – Máté Juhász – 2016-03-10T22:28:38.640

Do other formulas work? – Burgi – 2016-03-11T10:24:35.960

Answers

4

On the Formulas tab, can you check that Show Formulas option is not clicked? If it is clicked Excel does not evaluate the formulas, instead shows the formula's itself in the cells. enter image description here

Özkan ÖZLÜ

Posted 2016-03-10T22:18:34.103

Reputation: 325

Asked: 2016-03-10T22:18:34.103

Viewed: 72 times

Active: 2016-03-11T11:15:50.517