This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I am trying to use the TRIM() Function to remove white space from a column on my excel sheet.
The following image shows what my trouble is. Both columns, Status and Column2 are text columns. The function I used for the first value in Column2 was "=TRIM(A3)"
The pivot table has originally come from a MySQL database, I imported the data (permanent import) using the MySQL for Excel add-in, could this be causing me problems?Any help would be greatly appreciated.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Column2 shouldn't be a text column. As a text column, Excel won't recognize the formula as a formula, but will treat it as text. You'll need to change the column's cell format to General and probably will need to insert a new column and enter the formula in there to make it work properly.