How to get value a field based on of two other columns?

  • Thread starter Thread starter jamal ZETAWI
  • Start date Start date
J

jamal ZETAWI

How to get value a field based on of two other columns?
Case:
If the first value in the first column is 23 and the corresponding value in
the next column is AA, I need the corresponding value in the third column to
be 23AA, how to get this result?

Thank you
 
How to get value a field based on of two other columns?
Case:
If the first value in the first column is 23 and the corresponding value in
the next column is AA, I need the corresponding value in the third columnto
be 23AA, how to get this result?

Thank you
Click to expand...

using A1 and B1 ... this formula woks: =(A1&B1)
note the sign is an ampersand, not a "+" ...
 
Back
Top