How can I get it to auto enter <p>?

[suttercain]

Hi everyone,

I have two columns "K" which is the story column, and "L" which is the plot column. I copy and plast information in to boths of those columns but the I have to hand enter <p> and the end of each pasted text.

Example if I copy and paste "Little Chimps, the Story of the Amazon" I then have to hand enter <p> so the cell will be "Little Chimps, the Story of the Amazon<p>"

Is there a way I can have the <p> appear automatically at the end of any text I paste into both of those cells? It would save me so much time.

I would appreciate any help or suggestions.

Thank you in advance.

Shannon

[VBA Noob]

Hi,

Could give this code a try.

I assumes the quote mark are not in the cell

Please Login or Register  to view this content.

VBA Noob

[suttercain]

Hi VBA,

I tried it and it doesn't seem to be working. Do I have to change anything in the code you posted?

I copied it from here and pasted it into the K column in the function and I can't get.

PS. Yeah, there are no " " in the text.

Thanks again.

SC

[VBA Noob]

Hi,

Sorry it's a macro. See attached for an Example.

The link at the bottom of the post has a link showing you how to add code

If you want a formula try

=A1&" <p>"

VBA Noob