Step 1: To concatenate cells in Excel without using its formula, enter, for example, =A2 & B2. This will save you from entering the formula itself, which, in this case, would be =CONCATENATE(A2,B2) .

4] Use the CONCATENATE function We use the CONCATENATE function to join different text values, but it is also possible to use it to remove scientific notation. Now, this function works the same ...