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?
|