How to remove extra spaces for SQL data

Deleted
Not applicable

Hi Everyone,

 

I am pulling data from my inventory, but the Item# have extra spaces so i can't use vlookup in Excel. Can you please show me how to remove the extra trailing and leading space? such as where to enter the formula and how in SQL?

 

Thank you in advance!

4 Replies
Have you tried TRIM which should drop the extra spaces?

Hi @MickeNy 

 

How do you ensert the Trim function in SQL statement? Sorry  I am very new to SQL

 

Thank you

@Deleted I’m not sure how to do it within an SQL statement but assuming that you have a faulty value in your sheet that you want to use in a sql query you would first apply the TRIM to the faulty cell reducing the leading and trailing spaces from it and then use the resulting cell as your sql-statement source.

 

sample: a1 contains ”   Abc   ”

Writing the following formula TRIM(a1) in a2 would make a2 content ”Abc”

Then you would use a2 in your sql statement to find what ”Abc” stands for.

 

I hope this helps!

Thank you @MickeNy 

 

I will try your method. 

 

Thank you so much for your time