adding prefix and suffix macro

Hi. I wonder if anybody can help me in tracing a script to add a prefix text ( or suffix ) to an entire column, I use to have a VBA script for it but now lost