Right click sheet tabview codeinsert thischange range to suit

Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, Range("f2:f22")) Is Nothing Then Exit Sub
Application.EnableEvents = False
Target.Value = "PL" & Target
Application.EnableEvents = True
End Sub


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Mike Busch" wrote in message
...
I would like to place a prefix for suffix in every cell, either or. I need
to
place a part number that starts with the same tow letters, say PL, and
then I
would like to only type in the part number but have the prefix in the same
cell, exp. type in 097886 and have PL097886 appear in the cell. Is this
do-able. Thanks in advance.