Modern Vespa

I have been playing with spreadsheets since Visicalc, but I cannot for the life of me figure out how to append data to existing data in a cell in Excel 2007.

e.g.

A1= AAAAA, B2= BBBBB
Required result: A1= AAAAABBBBB

How hard can it be? Click on B2, Hit Ctrl-C, click on A1, put the cursor at the end of the data in the formula bar, hit Ctrl-V

All I get is a 'bonk' sound from Windows XP or Excel meaning "Naughty boy".

Edit:
I can use the CONCATENATE function, but what a drag:
C7: =CONCATENATE(A1,B2)
Then copy C7, and "Paste Values" into A1.

Eeesch.

Wouldnt that just be A1+B2

If you don't like CONCATENATE...

Can be done with a (really!) simple macro.

1 ) Turn on macros by enabling the "Developer" tab in your Excel ribbon. I don't know your version, but it should be in 'Options'.

2 ) Click Developer

3 ) Click Macros

4 ) Name your new macro in the box at the top like
AddTextToCell

5 ) Click "Create"

6) Between the Sub AddTextToCell () and End Sub() lines, paste these:
With ActiveCell
.Value = ActiveCell.Value & "BBBBBB"
End With

7 ) Click "Options"
assign the key to, say the 'o', so that Ctrl+o executes the macro

8 ) Close the Macro window.

Now in the cell with contents "AAAAA", select that cell, press Ctrl+o, and you will get AAAAABBBBBB

-sharpcolorado

That adds numbers together. I want to concatenate text data.

If you want to select a range of cells to do this on, paste this instead:

For Each c In ActiveCell.CurrentRegion.Cells
c.Value =ActiveCell.Value & "BBBBBB"
Next


That way, you could do only a single cell, or multiple cells in one swoop!

If you wish to specifically add the text contents of, say Cell B2 into A1, then:

ActiveSheet.Range("A1:A1").Value = ActiveSheet.Range("A1:A1").Value & ActiveSheet.Range("B2:B2").Value

Like Sharp says, try ampersands

=A1 & A2 strings together A1A2

Or if you can string text together

= "Vespa " & "P200" the result is Vespa P200

Cool! Instead of "BBBBB" can I make the macro "&" the contents of some other cell, e.g. B2, or the result of a COPY on the other cell?

[grumble] Be nice if Microsoft allowed the PASTE command to work in the formula bar [/grumble]

Of course, I could just type in the data I want. But that is not very elegant, is it?


(Now I AM dating myself. We old proggies used to strive for an 'elegant' solution to a programming program. And sneer at one which was not!)

You do realise you can copy and paste into the bar or cell once the text is selected?
Lots of clicks but it does work.

I can copy and paste from within the cell to other parts of the cell but I cannot paste data from another cell into the selected cell.

Excel 2007

Windows 7, excel 2007

Editing in cell, not formula bar:

Double click first cell to get cursor.
Double click again to select all text.
Ctrl-C to copy

Double click where you want to paste in destination cell.
Ctrl-V

Nope. I get the bonk. It works great in an empty cell, but not if I try to paste at the end of existing data.