When you import large data sets into Excel, some columns of text may not display in the case you would prefer. For example, you could have a column of names that are all upper case where you want only the first letter of the name to be upper case. Or you might have a list of model IDs that are lower case where you expected upper case. There are three functions for working with text that might be just the tools you need to improve the appearance of your data.The functions are UPPER, LOWER and PROPER. This function, =UPPER(A1) will convert the text in cell A1 to all upper case. Similarly, the function =LOWER(A1) converts all the text in cell A1 to lower case. The PROPER function converts just the first letter of the text in the designated cell to upper case.Proper Function The best way to convert a column of data is to:1)
You must be logged in to reply to this topic.