Dan,

Try this. If "NYCITY" is pasted in any row of column C, it will be replaced
by "NYC".

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 3 And Target.Text = "NYCITY" Then
Target.Value = "NYC"
End If
End Sub


"Dan R." wrote:

I know this is easy but I can't seem to figure it out, I need a macro
that will replace "NYCITY" with "NYC" if it is pasted in column 3.

Thanks,
-- Dan