View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
gmunro gmunro is offline
external usenet poster
 
Posts: 34
Default two word last names

If I am understanding you, I think you can do this with a formula
If C1 = Abdul
and D1 = Jabar
in cell E1, enter =C1&"-"&D1
E1's value will be "Abdul-Jabar"
Then just copy and paste as values.
(The "-" is to hyphenate the name.)

Does this help?