To capitalize the first letter of words inside all cells together in Excel, you can use the “PROPER” function along with the “Paste Values” feature. Here’s how you can do it:

1. Select an empty cell in your Excel worksheet where you want the capitalized text to appear.
2. In the selected cell, enter the following formula:

excel
Copy

=PROPER(A1)

Replace “A1” with the reference to the first cell containing the text you want to capitalize. This formula will capitalize the text in that specific cell.

1. Press Enter to apply the formula to the selected cell. You should see the capitalized text in that cell.
2. Now, copy the cell with the formula by pressing Ctrl+C (or Command+C on Mac).
3. Select the range of cells that you want to capitalize. This range should include all the cells that you want to modify.
4. Right-click on the selected range and choose “Paste Values” from the context menu. This action pastes the values from the copied cell, overwriting the original text with the capitalized version.

After following these steps, all the words inside the cells in the selected range will have their first letter capitalized. Remember to save your Excel file after making these changes.