Get All Capital/Uppercase Letter From Cell In Excel

In this post we will see how we could extract all the capital/uppercase letters from a cell in excel.

Below is an example where we have data in column A that has names that contains capital characters and we would like to get all the capital letters in the adjacent cell in column B.

table explaining how to get capital letters from cell in excel

Here in the data above we could see that we have capital letters in the initials of the names and also embedded between the characters in the name.

To get all the capital letters from a cell in excel, we will use SUBSTITUTE formula in excel.

Enter the formula in cell B1 as shown below in the figure and press enter.


excel formula to extract uppercase letters from cell

As we could see, we have got capital letters from cell A1.

enter formula in cell to get capital letters in excel

Now drag the formula to accommodate all data available in column A.

drag the formula to get all uppercase letter in excel

Hope this helped.

Share The Knowledge

Random Posts

Leave a Reply