EXCEL1: Macro to insert 1 Space

[aacod]

I have hundreds of names in column D from D5 to D5000.

I need to insert 1 space before the start of the name.

E.g.

Now:
Smith

Result:
Smith

Can anyone help with a macro?

Thanks.

aacod

 

[Oeldere]

Non VBA solution.

E5

=" "&d5

drag down.

Then Copy => paste special => values (Collumn E to D).

Delete collumn E.

I have a question?

Why is it important to add an " ".
Mostely the question is how to remove the " ".

 

[aacod]

Oeldere, Thanks for the NON VBA solution, which works.

The reason why I want a macro is because when I mail merge in word document to print, It may not recognize the name and may just print the formula!!!! Though not sure.

 

[Oeldere]

If you choose paste speical => values

There are no formula's in the cell.

In this case there will be no problem.

I don't mind you're seeking a solution with VBA, but i can't help you enough with that.

 

[Mjoza]

If you copy and paste special values, all the cell formulas will be deleted and only names will be shown so no need to worry about formulas printing.

 

[aacod]

OK Thanks, Works for me with PASTE SPECIAL.

 

[Oeldere]

Glad I could help. Thanks for the reply.<o></o>
<o> </o>
If the question is solved, will you mark your question as solved?<o></o>