Question

On the locations worksheet, change the formula in the abb column so it shows the first three letters of each location in lower case?

Answer 1

To show the first three letters of each location name in lower case in a spreadsheet, use the formula =LOWER(LEFT(cell_reference, 3)) where 'cell_reference' is the cell that contains the location name.

Step-by-step explanation:

The question is asking how to modify a formula in a spreadsheet to display the first three letters of each location in lower case. To accomplish this in most spreadsheet applications, you would use a combination of functions. First, use the LEFT function to extract the first three letters of the location name. Then, wrap that in the LOWER function to convert them to lower case.

For example, if the location name is in cell A2, the formula would look something like this:

=LOWER(LEFT(A2, 3))

This formula takes the location from cell A2, extracts the first three characters, and converts those characters to lower case. You would copy this formula down the 'abb' column to apply it to all location names.