...
- Right-click column B and select Insert to add a new column in which to work.
- In cell B2, type “=” to indicate the start of a formula.
- Type “=trim(”.
- Click cell A2 (Alabama).
- Type “)” (close parenthesis).
- Ensure your cell says “=trim(A2)” and press Enter to finish the formula.
- Copy the formula down the table.
...