You can also use the concatenate function to combine more than two columns. Step 1: I typed in =CONCATENATE(A2,B2,C2) into its own cell. Change the column letters to ones of your choosing, and ...

2] Using the Concatenate function to join and add space between words You can join text in different cells together and have space between them. Use the formula =CONCATENATE(A4, ” “, B4) .

It's easy to return random values in Microsoft Excel, but returning random letters might leave you scratching your head. Fortunately, you only need two functions.

Step 2: If you simply click on the Merge and Center button, then the "Q1 Sales" will be spread across the three cells and centered. Note that any data in the cells to the right will be overwritten ...

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