Hi Marv!
Yes, you can definitely use the
=TRIM and
=PROPER functions in a nested statement to clean up your text data. Here's how you can do it:
- First, select the cell where you want to enter the nested statement.
- Type the following formula:
Formula:
=PROPER(TRIM(A1))
- Replace "A1" with the cell reference of the text data you want to clean up. For example, if your text data is in cell B2, you would enter
Formula:
=PROPER(TRIM(B2))
- Press enter to apply the formula.
What this formula does is first remove any extra spaces from the text using the
=TRIM function, and then converts the text to proper case (i.e. capitalizes the first letter of each word) using the
=PROPER function.