Showing posts with label Excel Tips. Show all posts
Showing posts with label Excel Tips. Show all posts

Formula to combine the different values into One Date Column

Today I'll show you how to combine three columns that contain date values ​​different in a single column.

It’s a pretty simple formula. Entering all the data in the spreadsheet takes up most time.

  • First you’ll need to create a spreadsheet that looks similar to this one.

  • Select Cell D2:D8
  • And type in the following formula =DATE(A2;B2;C2).

  • Then Click CTRL+ENTER and you’re done, you’re spreadsheet should look like this.


Use the same formatting to multiple cells, the easiest way

I’m using the Format Painter Tool in this Excel Tip and Trick to apply to same formatting in non connecting cells.


  •  If you want to use the same formatting on “random” cells you need to click on cell A1.
  • And double click on the Format Painter Tool.
  • Now you can click on the cells you want to apply this formatting on.

You can also apply the Format Painter for columns or rows.

Now I want the same formatting as row 1.


  •  Now click on the 1 on the right side of the spreadsheet.
  •  Click on Format Painter
  •   And click on 5