How about recording a macro when you did
select the column
edit|Replace
what: NYCITY
with: NYC
replace all

Be sure to check all the options you want so your macro can record them.

"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

--

Dave Peterson