Fresh Excel Tips

In this article, we will learn how to return the numeric, or ASCII, code for the first character in a text string by using the CODE function in Excel. What this function does is that it returns the code corresponding to the currently used character set. Here is how we’ll apply it in our formula: How [...]

Today, we are presented with a tricky problem that we need to correct. In Column A, we have text that has spaces at both the left and right side of the text. This is a problem as we will be using this data for evaluation in other formulas. To correct this, we will be using [...]

Previously, we looked at how to use the UPPER and LOWER Functions to convert text between Upper and Lowercase. Today we’ll be learning how to convert the first letter in each word to a Capital letter and all other letters to common letters. To do this, we will be using the PROPER Function. This function [...]

In this example, we will be demonstrating how to convert text that is in lowercase to uppercase by using the UPPER Function. Here is the syntax that is used for the function: UPPER(text) text: Text to be converted to all uppercase letters. The text can be either a reference or a text string. For our example, we have [...]

Previously, we created a tutorial on how to compare two columns using the IF Function, you can view that tutorial HERE. The difference between both methods is that by using the EXACT Function, it will be able to distinguish between upper- and lowercase characters, while using the previous method cannot. Here is the syntax for [...]

In this example, we will be demonstrating how to use the SEARCH Function to separate first and last names. In more detail, we will be using the SEARCH Function to determine the space between parts of a text string. In our example, both first and last names will be listed in Column A and we [...]