Hi,

I need help with the project below. I wanted to move only the date in
to the Column A and if the data in the second column is empty then use
the date from previous cell. For example, B14 is empty so I want to use
the date which is in the cell B10. I have about 40,000 records like this
I need some easy fix to do this.

Please if anyone could help me with if there is some kind formula to
generate the output as I have it below. If you copy the text file in
the excel it will come up as I have it.

Any help can be appreciated. Thank you.


+-------------------------------------------------------------------+
|Filename: before after.txt |
|Download: http://www.excelforum.com/attachment.php?postid=4302 |
+-------------------------------------------------------------------+

--
xgunda420x
------------------------------------------------------------------------
xgunda420x's Profile: http://www.excelforum.com/member.php...o&userid=25559
View this thread: http://www.excelforum.com/showthread...hreadid=507382