Pasting values into cells without pasting over existing values

[hermithead]

For simplicity sake if I wanted to paste the letter A in to a cell that already had the letter B in it to make the cell read AB how could I achieve this?

Thanks

[zbor]

Depends what you want to achieve...

One way could be: Add column in front of A (new A... your A become B)...

Then in (new) B column you have A, in C you can write B, in D you can write 1 etc...

In first A1 write =CONCATENATE(B1,C1,D1,E1) (etc)

sou you'll get AB1

[rwgrietveld]

zbor gives a good solution, but your quote

For simplicity sake

gets in the way as for simplicity sake just type AB.

What is it that you want to achieve. An example Sheet (upload) would be nice.

[hermithead]

I think that is the only way to do it ie creating a new column. It's a shame there is no special paste function that allows you to add values to existing cell content.

[zbor]

There is. But you would need to provide more details.

An example workbook would be nice.

[hermithead]

Maybe this will help....

Workbook 1
Col A
Row 1 A
Row 2 C
Row 3 A
Row 4 B

Workbook 2
Col A
Row 1 B
Row 2 D
Row 3 B
Row 4 A

Workbook 3 - a combination of 1 and 2 above
Col A
Row 1 AB
Row 2 **
Row 3 AB
Row 4 BA

When I paste the values from workbook 1 into workook 2 naturally it pastes over the values in workbook 2. My question is how can I retain the values in workbook 2 without pasting over them?

[hermithead]

the two ** should display as ** - dont know why it isnt showing up, tried to edit with no luck!

um why doesnt the letter C and D show up together?

[zbor]

And why can't you paste then in column next to it and concantenate :D

[rwgrietveld]

Are these different Workbooks or worksheets?

Assuming that it is the first ou can simply use:

Put this in WB3, Sheet1, Cell A1

Please Login or Register  to view this content.

and drag down

When closing WB1 and WB2 it will automatically change to (e.g.)

Please Login or Register  to view this content.

[hermithead]

And why can't you paste then in column next to it and concantenate :D

The workbook is 20 columns wide so setting a column up for each and entering a formula would be marginally faster than than copy and paste

[hermithead]

Are these different Workbooks or worksheets?

Assuming that it is the first ou can simply use:

Put this in WB3, Sheet1, Cell A1

Please Login or Register  to view this content.

and drag down

When closing WB1 and WB2 it will automatically change to (e.g.)

Please Login or Register  to view this content.

Two different workbooks. Excellent I'll give it a try.