Hi guys
If I have column A which contains mostly values and some blanks and column B all with values; how can I copy whole column A and paste to B but not paste all the blanks from column A (so that the B-values stay)?
Thank you!
Hi guys
If I have column A which contains mostly values and some blanks and column B all with values; how can I copy whole column A and paste to B but not paste all the blanks from column A (so that the B-values stay)?
Thank you!
Highlight column A. Copy. Select the first cell in column B. Paste Special.... Choose Skip Blanks. OK.
Pauley
--------
If I helped with your issue, I'd appreciate a rep bump (hit the '*' icon to the bottom left of this post).
Put the following formula in column C:Drag it down, then copy column C and do a PasteSpecial(values) into column B. Then delete C.Formula:Please Login or Register to view this content.
Acts 4:12
Salvation is found in no one else, for there is no other name under heaven given to mankind by which we must be saved.
Hmm. Pauleyb's way is better
If you don't want to overwrite the values in column B (which you don't say), select the range in Column A that had the data, blanks and all. Click on Find and Select, Go to Special, Constants, OK. Copy. Click at the bottom of Column B and Paste Special, Skip Blanks, OK. All the values of Column A without the blanks will be pasted onto the end of the data in Column B.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
Okay, I believe it works. Thank you guys!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks