How to remove Space in a cell?

[WillowD]

Hi All, Newbie needing Help here.

I have received a file from an SQL script that was saved into Excel format. I noticed there are spaces in all the colums at the beginning of each result. I tried to use the TRIM function but as usual the Noob in me has no idea what it is. If anyone could Guide me in step by step (in a simple English preferrably ) it would be much appreciated.

PS: I was trying to add a screen shot to explain my problem but I guess this Forum wont allow it.

PPS: Saved it as attachment..

[royUK]

Attach an example workbook instead of the screen shot

[WillowD]

As per request here is the sample of the actual workbook.

[royUK]

This code will clear the leading spaces

Please Login or Register  to view this content.

Copy the Excel VBA code
Select the workbook in which you want to store the Excel VBA code
Hold the Alt key, and press the F11 key, to open the Visual Basic Editor
Choose Insert | Module
Where the cursor is flashing, choose Edit | Paste
To run the Excel VBA code:

Choose Tools | Macro | Macros
Select a macro in the list, and click the Run button

[WillowD]

Thank You!! It worked.

[royUK]

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save