Macro to add spaces to beginning of each cell value

[eirwin1]

I am in the process of trying to create a macro that will insert two spaces to the beginning of each cell in an entire column. I have created it to successfully select an entire column but I can't seem to get the macro to add the two spaces before the text in the cell. My macro is as follows:

Please Login or Register  to view this content.

Any ideas on what is wrong in my code? Thank you.

[TankBuilder88]

Misread question. This will add it to the first 1000 cells of column A

Please Login or Register  to view this content.

[stnkynts]

Try this:

Please Login or Register  to view this content.

[berlan]

Another option applied on constants:

Please Login or Register  to view this content.

or alternatively,

Please Login or Register  to view this content.

[G e r a r d]

Try this:

Please Login or Register  to view this content.

If you have numbers in the column and want te change them to text you can also set the format for the cell as text format

Please Login or Register  to view this content.

[eirwin1]

Thank you so much. These posts were all very helpful. I greatly appreciate it. Do you know if this macro can be put into a template?