Excel Guides

Adjusting Test Scores Proportionately in Excel

There are a few different ways to adjust test scores proportionately in Excel. One way is to use the PROPER function. This function will take a text string and change it to proper case, which is the first letter of each word in uppercase and the rest of the letters in lowercase. So, if you have a list of names in all uppercase or all lowercase, you can use the PROPER function to fix them. For example, if your list looks like this:

AARON MURRAY
BRITTANY WALKER
CAMERON JOHNSON

You can use the following formula to change them to proper case:

=PROPER(A1)

Which would give you this result:

Aaron Murray
Brittany Walker
Cameron Johnson

You can also use the TEXTJOIN function to concatenate cells, which is useful for combining text from multiple cells into one cell. For example, if you have a first name in one cell and a last name in another cell, you can use TEXTJOIN to put them together in one cell. The syntax for TEXTJOIN is:

=TEXTJOIN(delimiter, ignore_empty, text1, [text2], ...)

Where delimiter is the character that will go between the text strings being joined, ignore_empty is a boolean value that specifies whether empty cells should be ignored or not, and [text2], ...] are the cells or ranges of cells that you want to join together. So, using our previous example, if your first names are in column A and your last names are in column B, you could use this formula to put them together in column C:

=TEXTJOIN(" ",TRUE,A1:A3)

(The TRUE value for ignore_empty tells TEXTJOIN to ignore any empty cells in columns A and B.)

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.