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).

If you want to combine your words using an ampersand and add a space between them, use the formula =CONCATENATE (A3, ” & “, A7). In the photo above, you will see that the texts are joined with ...

It is a more powerful alternative to the concatenation operator (&) or the CONCATENATE function, which are two other ways of concatenating strings in Excel. TEXTJOIN function is available in Excel ...

Divide the text/numbers in a set of cells that are either pure text or pure numbers and format them accordingly. Play with several widths.<BR><BR> my 2 cents,<BR><BR> Caos ...