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

04-16-2023, 10:19 PM

ArviLaanemets ArviLaanemets is offline

Windows 8

Office 2016

Expert

Join Date: May 2017

Posts: 949

When your data are starting from row 2 (e.g. row 1 being header):
Into some free column (e.g. X) into row 2 enter formula like

Code:

=IF(H2="","" & G2,H2)

and copy it down. Then copy the results, and use PasteSpecial.Values to overwrite column G

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:33 PM.