Inserting the letter "c" at the end of 5 characters in a cell

[indi visual]

I have 5 characters I would like the letter "c" placed at the end of. I've created a mark as complete button. My goal is to click the mark as complete button that adds a "c" at the end of characters in the cell.

I don't believe I can use a formula for this, because I can only place a "c" when the job is marked as complete.

I'm afraid a formula will just place a "c" down the whole column on everything.

A click sub macro button code that can offset 5 characters spaces would be golden.

 

[PowerEngineer]

I'm not sure I really understand what you want, however this line of code should do what you want:

Worksheet("Sheet1").Range("a1").value = Worksheet("Sheet1").Range("a1").value & " c"

Assuming that your character string is in cell a1 on Sheet1.

I'd be inclined to set up a separate cell immediately to the right of your character string to put the "c" in. You might also look into check boxes.