Thread: Adding Text
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default Adding Text

First change the xx in the following macro to your prefix.
Then select the cells you want to modify
Then run the macro


Sub prefixx()
For Each r In Selection
r.Value = "xx" & r.Value
Next
End Sub

--
Gary''s Student - gsnu200806


"Brent" wrote:

I have a whole page of different names and I need to add the same two letter
prefix to the beginning of each of them?