Final answer:
To put text from cell B2 in proper case in cell B3, use the formula '=PROPER(B2)' which capitalizes the first letter of each word.
Step-by-step explanation:
To display the text from cell B2 in proper case with only the first letter of each word in upper case in cell B3, you can use the following formula:
=PROPER(B2)
This formula takes the text in cell B2 and converts it to proper case, meaning that the first letter of each word will be capitalized, and all other letters will be in lowercase, which is exactly what is required for your spreadsheet. If the text in B2 is 'john doe', after applying the PROPER function in B3, it will display as 'John Doe'. This function is quite useful in scenarios where you need to standardize the capitalization of names or titles in your data.