merge or add?

  • Thread starter Thread starter Alan
  • Start date Start date
A

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
 
Will this work?

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