Quite often, when working with Excel spreadsheets, situations arise when you need to replace the first lowercase letter of a word with an uppercase (capital) letter.
Of course, when it comes to several cells, editing their contents is not difficult and does not take much time. But what to do when you have to deal with large tables? You should not immediately take up manual data correction, which, moreover, can lead to typos. Indeed, in this case, Excel provides special functions that allow you to perform the replacement automatically. Let’s see how exactly this is done.