videoflyer
Registered
I have an Excel spreadsheet in which each cell in one particular column contains a concatenate function to produce the necessary values. Now, for ease of copy/pasting the resulting values into other documents, I've been attempting to copy that column and 'paste>special>values' into a new one. My problem is that it appears that the new column has had some of the values removed with the remaining cells in the column being shifted upward so that the further down the spreadsheet I go the more out of sync this column becomes from the rest of the spreadsheet.
The weird (to me, at least) part is that if I copy/paste each individual cell in the formula column into my values column every thing is fine - the values paste in exactly as they should. Obviously, though, I'd prefer to accomplish this operation all in one shot.
Is there some secret step I'm missing? Why would copy/pasting the entire range drop some of the values which, when copy/pasted individually, work just fine?
The weird (to me, at least) part is that if I copy/paste each individual cell in the formula column into my values column every thing is fine - the values paste in exactly as they should. Obviously, though, I'd prefer to accomplish this operation all in one shot.
Is there some secret step I'm missing? Why would copy/pasting the entire range drop some of the values which, when copy/pasted individually, work just fine?