Let's say I have a text called 'Boy' in cell A1. Now if I have to append the letter 's' at the end, I have to either click the formula bar and add 's' at the end or press F2 to go to edit mode and then add it. Is there any way or any add-in which allows me to simply append value to a cell which already has some text in it?
You can use the
You already explained the other manual ways. Another way would be to use a macro in combination with an user-input or user-input-form.
It could work like this:
Another way might be using the search/replace functionality.
Although I find this a strange way to type in data, and would not rant against MS in this point - here is a somewhat solution to this refined behavior:
|show 4 more comments|