Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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?

share|improve this question
add comment

1 Answer

up vote 1 down vote accepted

You can use the CONCATENATE formula, or something like =A1 & "s".

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:

  • select the range/cell, where appening should happen
  • excecute macro through e.g. shortkey
  • dialog pops up to aks for text to append
  • type text
  • execute appending

Another way might be using the search/replace functionality.

Edit

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:

'VBA code for Sheet1

Private var As Variant

Private Sub Worksheet_Change(ByVal Target As Range)
  On Error Resume Next
  If state Then
    Application.EnableEvents = False
    var = var & Target.Formula
    Target.Formula = var
    Debug.Print var
    Application.EnableEvents = True
  End If
End Sub

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
  If state Then
    var = Target.Formula
    Debug.Print var
  End If
End Sub

'VBA Code for Module1

Public state As Boolean

Public Sub switchState()
  Application.EnableEvents = True
  state = Not state
  Debug.Print state
End Sub
share|improve this answer
    
But I don't want to use any of these. I just want to start typing and text should append at the end. I have searched a lot, couldn't find any solution :-(.. Microsoft is so stupid not to provide this option! –  thandasoru Nov 21 '12 at 16:53
    
ok, so you want to select a random cell, and then, just by typing in values it should append them. And I would guess there should somewhere be an option to activate/deativate this behaviour right? –  Jook Nov 21 '12 at 17:25
    
yes, if it is available kindly let me know.. or at least is there anyway to change the shortcut key F2 to F6? I am asking this for a very important reason. I use a Dell Studio 1555 and the laptop has a mind of its own. I set the function keys behavior to Function key first, but after couple of days, it resets back to multimedia keys first. since my F6 key is empty, I thought of assigning the key to Edit mode –  thandasoru Nov 21 '12 at 17:26
    
wow, thats a lot of code.. can you guide me what to do with this code? –  thandasoru Nov 21 '12 at 17:29
    
@thandasoru - see my edit. I don't really like this solution, but it kinda does what you want. Would not lable MS stupid because they did not provide this, this is quite an confusing behavior. –  Jook Nov 21 '12 at 17:30
show 4 more comments

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.