Images loading below. While you wait, can you answer this Excel related tip? Guess the answer then click SEE ANSWER to see how it can be done.

1. How do you take all the formatting from chart (see 1 below) and PASTE it onto another chart (2)? Guess and then see how it can be done with 'See Answer'

2. How do you copy from Excel (see 1 below) and paste into Word (2) WITHOUT seeing the filter button, gridlines, comment notes and more?

Guess and then view answer to see how it can be done!


CSV semicolon instead of comma

You work often on CSV files in Excel and suddenly the CSV uses semicolon instead of comma, or comma instead of a semi colon. This sometimes happens when you have changed computers or if you receive the CSV file from a different source.

YouTube CSV semicolon instead of comma

Watch, like, subscribe

Force the CSV to use a comma (or semicolon)

Your computer may be set up to open all CSV’s in Excel without allowing you to change the settings. If this is the case, instead of double clicking the file from outside Excel, rather Open Excel and tell it you are Importing Text. Note for the below you may need to switch back on the legacy import buttons.

As per below, open Excel (without opening the CSV file) and click

  • on the DATA ribbon,
  • choose GET DATA,
  • then LEGACY WIZARDS (if you can’t find this switch it back on here),
  • and then FROM TEXT (LEGACY)
CSV semicolon instead of comma

The following screen will appear. Note that in the Red box you can see the problem. There are semicolons instead of commas. Make sure you choose the delimited option

In the next screen you can specify that this csv is split by semicolons and you will immediately see that Excel now knows where to split it.

You can now click FINISH and the CSV split with semi colons will appear correctly in columns.

Excel formulas need a semicolon instead of a comma?

Excel CSV opens in one column

The Excel Online Course that covers importing CSV’s