adding data to the left/right of existing data

[lines_michael]

I have three columns that I am working with. All currently contain data.

D2 one sentence of text
E2 one sentence of text

G2 a bunch of imported html code

I am trying to add some html to format the text that I am copying to G, then copy data to the beginning of column G

I would like to have G look like this in the end

<P align=center><STRONG>"COPY CONTENTS OF COLUMN D"<BR>"COPY CONTENTS OF COLUMN E "</STRONG></P><BR> CURRENT CONTENTS OF G

all changes will be in the same corresponding rows and data starts in 2nd row

[NBVC]

You should supply several samples of what it looks like to start and indicate what changes should be made... to get to the final result.

[mikerickson]

="<P align=center><STRONG>" & D2 & "<BR>" & E2 & "</STRONG></P><BR>"

[NBVC]

Should have read it more in depth... looks like Mike's should work for you