merge or add?

[Alan]

I am using XL 2002. I have a bunch of cells that are basic numbers [example
001262] I need to automatically merge a name in front of that number - to
turn '001262' into 'Furman 001262'

Can someone advise of the syntax needed and any suggestions on automated
ways to do this? I have thousands of fields to update with several dozen
names, on a regular basis!
thank you !
Alan

 

[Don Guillett]

Will this work?

Sub addname()
For Each c In Selection
c.Value = "Furman " & c
Next
End Sub