+ Reply to Thread
Results 1 to 11 of 11

Pasting values into cells without pasting over existing values

  1. #1
    Registered User
    Join Date
    08-12-2009
    Location
    Perth, WA
    MS-Off Ver
    Excel 2003
    Posts
    93

    Pasting values into cells without pasting over existing values

    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

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,404

    Re: Pasting values into cells without pasting over existing values

    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

  3. #3
    Valued Forum Contributor rwgrietveld's Avatar
    Join Date
    09-02-2008
    Location
    Netherlands
    MS-Off Ver
    XL 2007 / XL 2010
    Posts
    1,671

    Re: Pasting values into cells without pasting over existing values

    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.
    Looking for great solutions but hate waiting?
    Seach this Forum through Google

    www.Google.com
    (e.g. +multiple +IF site:excelforum.com/excel-general/ )

    www.Google.com
    (e.g. +fill +combobox site:excelforum.com/excel-programming/ )

    Ave,
    Ricardo

  4. #4
    Registered User
    Join Date
    08-12-2009
    Location
    Perth, WA
    MS-Off Ver
    Excel 2003
    Posts
    93

    Re: Pasting values into cells without pasting over existing values

    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.

  5. #5
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,404

    Re: Pasting values into cells without pasting over existing values

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

    An example workbook would be nice.

  6. #6
    Registered User
    Join Date
    08-12-2009
    Location
    Perth, WA
    MS-Off Ver
    Excel 2003
    Posts
    93

    Re: Pasting values into cells without pasting over existing values

    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?
    Last edited by hermithead; 02-09-2010 at 04:26 AM.

  7. #7
    Registered User
    Join Date
    08-12-2009
    Location
    Perth, WA
    MS-Off Ver
    Excel 2003
    Posts
    93

    Re: Pasting values into cells without pasting over existing values

    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?
    Last edited by hermithead; 02-09-2010 at 04:32 AM.

  8. #8
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,404

    Re: Pasting values into cells without pasting over existing values

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

  9. #9
    Valued Forum Contributor rwgrietveld's Avatar
    Join Date
    09-02-2008
    Location
    Netherlands
    MS-Off Ver
    XL 2007 / XL 2010
    Posts
    1,671

    Re: Pasting values into cells without pasting over existing values

    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.
    Last edited by rwgrietveld; 02-09-2010 at 04:56 AM.

  10. #10
    Registered User
    Join Date
    08-12-2009
    Location
    Perth, WA
    MS-Off Ver
    Excel 2003
    Posts
    93

    Re: Pasting values into cells without pasting over existing values

    Quote Originally Posted by zbor View Post
    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

  11. #11
    Registered User
    Join Date
    08-12-2009
    Location
    Perth, WA
    MS-Off Ver
    Excel 2003
    Posts
    93

    Re: Pasting values into cells without pasting over existing values

    Quote Originally Posted by rwgrietveld View Post
    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.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1