Concatenate Strings to specified column until last row

I am working on a macro how to concatenate the string "Proposal" and ":" in the Column B such that if the Column B consist a number 1 then the updated Column B has to be Proposal 1:. I know that the concatenation formula allows us to do that but i need to loop over until last row. Can anyone help me the macro that does this? here is the attached sample file.

hi, the requirement is the same but I need a macro for doing that since I get this file on daily basis. And I need it to be done automatically by single click of button.

If you want to change actual value in the cell then.

Please Login or Register  to view this content.

Does this help?

Please Login or Register  to view this content.

Then try this one

Please Login or Register  to view this content.

Amended:

Please Login or Register  to view this content.

Thank you all. What if I need to concatenate another column just like Column B. Say I need to add Column C with the String "Proposal Text". Do I need to add the range as "C" and add the same formula?

In that case change to

Please Login or Register  to view this content.

But I have different string to be concatenated into Column C "Proposal Text". I don't understand how resize work here?

Yup what you meant is close. But if I need a random Column D to have concatenated with string "Vote 2013". Example, Column B concatenated with "Proposal " and Column D concatenated with "Vote 2013".

Alter Array as you want.
First letter = Column reference, 2nd string = trailing string for respective column

Please Login or Register  to view this content.

hi john,
when i tried hyour code that you specified in this post:

Please Login or Register  to view this content.

I just tried to concatenate 2 more columns with the string "Vote for 2013 and Vote for next year" I got it concatenated but when I run the macro second time it concatenate the strings twice. here is the code that I have modified.

Please Login or Register  to view this content.

Please help. I have attached the sample data sheet as well.

What do you need to happen. Why would you run it twice?

First of all, I get this sheet in daily basis and the user would run this macro to concatenate specific strings and then generate reports based on this. Sometimes there are chances that the user would trying running more than once which would lead to wrong text added in the report. So That is why I need the strings that are already concatenated to be added once again.
For example,
the column D and E should have string "Vote for 2013" and Vote for next year" concatenated to the values of the column for the first time the macro is hit. But for the second time if the string is already present then it should not be concatenated.
Does that make sense?

Maybe this will give you more flexibility?

Please Login or Register  to view this content.

Hi john,
Now when I give the same column letter and string for the second time it prints the string twice. Example, first time execution the output of the macro is "Vote 2013 For: but second when I hit the macro button and I give the same column letter and string it gives me "Vote 2013 Vote 2013 For::". I don't want this to happen. I need it to be the same "Vote 2013 For:".

Hi john,
Can you tell me why this code doesn't work for the column D and E but it worked for Column B. That is, Column B get its string "Proposal" concatenated only once (if the macro is hit twice)but for D and E it gets concatenated twice. I don't understand the logic here?

Please Login or Register  to view this content.