I am trying to utilize the trim function in Excel. I enter the "=trim(A2)"
and press enter but leading spaces are still present. There are three leading
spaces in front of a customer name field and several trailing that I wish to
remove without having to manually do so. I have tried formatting the cells as
text or as general with no sucess.

Each time I still get " account name "

Am I missing a step?