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

Originally Posted by Carim

Hi,

Do you really need a macro ...?
What about concatenation ...
=A1&B1&C1

Kind of you to suggest but I used to have the macro for it as I'm adding a text as a prefix and suffix and I'm not sure hw to use your tip not being excel master.

Basically creating metatags to a series of data in my database so for each cell I have to put <META NAME="Keywords" content=" as a prefix and "> as suffix
This to apply the entire column

I remember I used to do it in 2 times using the same script which did ask for a text to add as prefix or suffix

Originally Posted by Bryan Hessey

Hi,

Please Login or Register  to view this content.

should do that for you, adjust the column if it is not A

hth
---

Much Appreciate thanks!!!