Home > OS >  First aid, in Excel how to implement C=A B? Not peace!
First aid, in Excel how to implement C=A B? Not peace!

Time:09-29

First aid, in Excel how to implement C=A + B? Is not the sum, as shown effect:

CodePudding user response:

Change the format to the text, so it won't be a sum

CodePudding user response:

CodePudding user response:

& +=a1 & amp; + b1 & amp; +...

CodePudding user response:

=A1 & amp;" + "B1

CodePudding user response:

=a1 & amp;" + "& amp; b1

CodePudding user response:

Use & amp; Connection is ok, need to write the + + number

CodePudding user response:

Among A, B plus one column, and the content is +, then D=A + B + C

CodePudding user response:

=A1 & amp;" + "B1

CodePudding user response:

=A1 & amp;" + "& amp; B1

CodePudding user response:

Use & amp; Symbols, C=A1 & amp; B1

CodePudding user response:

Input in the C1=concatenate (A1, "+", B1)

CodePudding user response:

=a1 & amp;" + "& amp; b1
  • Related