If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
concatenate will not paste special
Hi
I am trying to concatenate first name and last name columns, all is good till I copy and paste special.....It say copy and paste area is not the same size...and it is. Here is the real dilemma, when I copy and past the data into a new spread sheet and concatenate it works, except in certain records it drops the actual name and I end up with a blank field, that causes great grief when I send said data to another process that strips blank lines and shifts remaining data up resulting in an absolute train wreck of srong names to addresses. Help |
#2
|
|||
|
|||
concatenate will not paste special
If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet 2. You give me the newsgroup and the subject line 3. You send a clear explanation of what you want 4. You send before/after examples and expected results. -- Don Guillett Microsoft MVP Excel SalesAid Software "CBB" wrote in message ... Hi I am trying to concatenate first name and last name columns, all is good till I copy and paste special.....It say copy and paste area is not the same size...and it is. Here is the real dilemma, when I copy and past the data into a new spread sheet and concatenate it works, except in certain records it drops the actual name and I end up with a blank field, that causes great grief when I send said data to another process that strips blank lines and shifts remaining data up resulting in an absolute train wreck of srong names to addresses. Help |
#3
|
|||
|
|||
concatenate will not paste special
Are there any hidden rows or columns within the range you are copying &
pasting? Hope this helps, Hutch "CBB" wrote: Hi I am trying to concatenate first name and last name columns, all is good till I copy and paste special.....It say copy and paste area is not the same size...and it is. Here is the real dilemma, when I copy and past the data into a new spread sheet and concatenate it works, except in certain records it drops the actual name and I end up with a blank field, that causes great grief when I send said data to another process that strips blank lines and shifts remaining data up resulting in an absolute train wreck of srong names to addresses. Help |
#4
|
|||
|
|||
concatenate will not paste special
Do you have any merged cells involved in this operation?
If so, get rid of them. Gord Dibben MS Excel MVP On Wed, 2 Jun 2010 08:33:01 -0700, CBB wrote: Hi I am trying to concatenate first name and last name columns, all is good till I copy and paste special.....It say copy and paste area is not the same size...and it is. Here is the real dilemma, when I copy and past the data into a new spread sheet and concatenate it works, except in certain records it drops the actual name and I end up with a blank field, that causes great grief when I send said data to another process that strips blank lines and shifts remaining data up resulting in an absolute train wreck of srong names to addresses. Help |
Thread Tools | |
Display Modes | |
|
|