Select the range that you want the addition on and run the Macro:

Sub AddIt()
For Each cell In Selection
cell.Value = cell.Value & "*"
Next cell
End Sub

HTH

Sandy

--
to e-mail direct replace @mailinator.com with @tiscali.co.uk


"Lin Light" wrote in message
...
I need to add an * to the end of all the numbers in my
Bib record column. Any suggestions. I was able to figure
out how to add in the front. Had to change a b to B and
add *, so it appears *B121212 now I need to had to the
end an * so I have *B121212*.
Lin

--
Lin Light Herrick District Library