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

2. What is the shortcut to ONLY select the visible cells? Guess, then click 'See Answer' as it can be done.

 

CSV now semicolon not comma

Suddenly your Excel CSV’s are now semicolon not comma. You can change this back to be a comma or else you can learn how to use semi colons instead of commas for CSV’s.

YouTube CSV now ; not ,

Watch, like, subscribe

Changing CSV’s back from semi colon to comma

In all likelihood this has happened when you are working on a new computer and it is a setting, not in Excel, but Windows.

So in Windows, search for the ‘Clock and Region’ settings, then

  • Choose the ‘Change date, time or number formats’ option
  • On the next screen choose ‘Additional Settings’, and
  • in the ‘Customize Format’ screen, check what is listed as the ‘List Separator’. This will be what Excel uses as the delimiter so if you need to change it, you can do it here.
CSV now semicolon not comma

So now you won’t have a CSV using semicolon instead of a comma. You can use the same process if you actually want your ‘Comma Separated Files’ to rather be ‘semi colon separated’ files.

Excel formulas need a semicolon instead of a comma?

Excel CSV opens in one column

The Excel Online Course that covers importing CSV’s

Decimal commas instead of points in Excel