3] Use the Concatenate function to join and add a comma between words You can also add a comma between your words by using the formula =CONCATENATE (A3, ” “, B3, “,”, 90).

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

=CONCATENATE(C3,B4,",") Figure C It’s the same expression we used earlier, but it omits the need for a helper column. In addition, you’ll probably need to delete the last comma in the string.

Type "=CONCATENATE (A1,A2)" in an empty cell to concatenate the values in cells A1 and A2. As an example, if cells A1 and A2 contained the unquoted words "hall" and "mark," the result would be ...

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