Imported data with blanks in front

[ktomblin]

I have imported data coming into excel with tons of blanks in front of the number. Is there a formula that will remove the blanks? If I paste it in a text file it comes across with "" so for example it looks like this "3434" I think it has something to do with formatting? I can't just format as a number or do text to coumns to remove the blanks.

 

[mirabeau]

Have you looked at?
http://office.microsoft.com/en-us/excel-help/trim-function-HP010062581.aspx

 

[Fazza]

If the import process allows, try VAL(YourField) in the SQL.