LinkBack URL
About LinkBacks
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
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
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
zbor gives a good solution, but your quotegets in the way as for simplicity sake just type AB.For simplicity sake
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
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.
There is. But you would need to provide more details.
An example workbook would be nice.
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.
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.
And why can't you paste then in column next to it and concantenate :D
Are these different Workbooks or worksheets?
Assuming that it is the first ou can simply use:
Put this in WB3, Sheet1, Cell A1
and drag down
Please Login or Register to view this content.
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.
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 pasteOriginally Posted by zbor
Two different workbooks. Excellent I'll give it a try.Are these different Workbooks or worksheets?
Assuming that it is the first ou can simply use:
Put this in WB3, Sheet1, Cell A1
and drag downPlease Login or Register to view this content.
When closing WB1 and WB2 it will automatically change to (e.g.)
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks