Import xls file, keep leading zero, get rid of spaces

[rinser]

Hi everybody,

I have a problem which may seem simple but is daunting for me.
I have a file in xls format that i need to import data from.
The problem is with column A, (e.g. 0233 45) if I get rid of the spaces I loose leading zero, if I keep the zero I cannot get rid of spaces. The thing is I need both conditions satisfied.
To summarize:

1)Import file and delete columns B and C
2)In column A get rid of spaces but keep leading zero (it's important to keep the zero where it exists, not add one). The length is different for each string in column A.

Here is a small sample of the file that is imported
import and convert.xls

If anyone knows how to do it please share.
Any help of idea will be appreciated.

[DonkeyOte]

If you want to keep the leading zeroes and numbers are of varying lengths then I think you will need to store as text...

Perhaps then:

Please Login or Register  to view this content.

[rinser]

Thank you for fast reply DonkeyOte!

I have applied the solution and it works perfectly!

Thank you very much!
Cheers