How to Add Text/Value of 2 or more cells in Excel

0
dpjadmin
Jan 21, 2025 03:30 PM 0 Answers General
Member Since Feb 2023
Subscribed Subscribe Not subscribe
Flag(0)

To Add text of two or more cells in Excel you have to use the Formula Bar which is shown above the work area of sheet with a symbol of functions.

Type in the formula bar "=CONCATENATE(A1,B1) and so on

It will provide the result as below

To add numbers in two or more cell you have to use the "+" sign with the address of cells like this

See the difference in adding ofnumbers as text

1 Subscribers
Submit Answer
Please login to submit answer.
0 Answers
Sort By: