When you calculate prices you usually know the cost price and the desired profit percentage, so all you have to do is to add the profit to the cost price in order to calculate the sales price. However, the price list might not look as nice as you want:

READ MORE# Create random text strings and line breaks with the CHAR function

## How to generate a string of random letters in Excel

The CHAR function returns a character that corresponds to the number in the character set used by your computer (ANSI for Windows). There are up to 255 different characters in the set, with the capital letters from A-Z starting at number 65. Z is 90. To generate a random letter you can use the RANDBETWEEN function:

# Join cells in Excel and remove excess commas between elements

**EDIT: If you are using Excel 2019 or Office 365 you can use the TEXTJOIN function to solve this problem. Click here for the new article: **

**How to Join Text from Several Cells in Excel using TEXTJOIN **

Unclean data can cause a lot of problems in Excel. In this post I will show how you can join data from different columns with a comma between them. That’s the easy part. The problem occurs when you have empty cells in your data, like in the table below. The result of the first row looks fine, but if you look at the rows with empty cells, you get too many commas:

# Today’s Shortcut: Zoom in and Zoom out in Excel

This is a standard shortcut that works in most Windows applications, including all MS Office applications and all web browsers:

**Hold down the Ctrl key and use the scroll wheel of your mouse to zoom in and out. **

Of course, you can also use the zoom bar on the right bottom of the page, but when you know this shortcut you will probably never do that again!

## More shortcuts in Excel:

Are you using a non-English version of Excel? Click here for translations of the 100 most common functions.

# How to Calculate Grades in Excel

How can we calculate the grades (A-F) in Excel if we have the test results as numbers? We know that a score of 90% or higher is an A, 80-89% is a B, 70-79% is a C, 65-69% is a D and less than 65% is an F.

The first thing we should do is to organize this information in a lookup table:

# How to Copy Format in Excel

Sometimes some of the data in a table have the wrong format. Take a look at this table, where some of the records are in hh:mm format, and others in hh:mm:ss format.

Here is an easy way to fix it: