Copying column to another column with deleting date due to blank cells

		Microsoft Office Forums > Microsoft Excel > Excel
Copying column to another column with deleting date due to blank cells

FAQ

Thread Tools

Display Modes

04-18-2023, 06:10 AM

p45cal

Windows 10 Copying column to another column with deleting date due to blank cells

Office 2019

Expert

Join Date: Apr 2014

Posts: 956

Copy column H2:H53 (Ctrl+c)
Select G2, Paste Special… tick the Skip Blanks checkbox, OK.

2023-04-18_140917.png

It won't let you cut and paste special, so you'll have to delete column H afterwards.

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Select all cells in a column , even when blank...	Chayes	Excel Programming	4	05-30-2018 10:35 AM
Vlookup fill down blank cells in column	mbesspiata	Excel Programming	8	09-26-2016 04:44 AM
Auto Fill only Blank Cells in a Column	mbesspiata3	Excel Programming	1	09-22-2016 07:18 PM
Copying DNA from web and need to convert column date to ex: 11-15	JacMUr2	Excel	2	01-22-2016 03:36 AM
Return Sum value of one column from cells not blank in another column	zulugandalf	Excel	3	08-14-2014 03:37 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:34 PM.