|
copying cells
I am trying to copy data down. I need to fill each of the empty cells with
the data that appears above it before the occurance of the next data item. For example: 9B0B4C504A70A90B14DFDAB0ADBE477D - 464EED0D421A8763AE9E539B278257FC - - 5B0AB65A11D4BA460000459400000000 - - B2D45E0211D550F10100D58698469B02 - Becomes: 9B0B4C504A70A90B14DFDAB0ADBE477D 9B0B4C504A70A90B14DFDAB0ADBE477D 464EED0D421A8763AE9E539B278257FC 464EED0D421A8763AE9E539B278257FC 464EED0D421A8763AE9E539B278257FC 5B0AB65A11D4BA460000459400000000 5B0AB65A11D4BA460000459400000000 5B0AB65A11D4BA460000459400000000 B2D45E0211D550F10100D58698469B02 B2D45E0211D550F10100D58698469B02 ----------------------- sanpanico |
Test this first on a small sample so you are sure you get it right
select the range, press F5, select special and blanks. Now type in =A1 (where A1 is the first cell counting from the top, replace it with your first cell, i.e. the cell that in your examle holds 9B0B4C504A70A90B14DFDAB0ADBE477D) press Ctrl + enter Finally select the new range and copy it, then paste special as values in place to remove the formula Done! Regards, Peo Sjoblom "sanpanico" wrote: I am trying to copy data down. I need to fill each of the empty cells with the data that appears above it before the occurance of the next data item. For example: 9B0B4C504A70A90B14DFDAB0ADBE477D - 464EED0D421A8763AE9E539B278257FC - - 5B0AB65A11D4BA460000459400000000 - - B2D45E0211D550F10100D58698469B02 - Becomes: 9B0B4C504A70A90B14DFDAB0ADBE477D 9B0B4C504A70A90B14DFDAB0ADBE477D 464EED0D421A8763AE9E539B278257FC 464EED0D421A8763AE9E539B278257FC 464EED0D421A8763AE9E539B278257FC 5B0AB65A11D4BA460000459400000000 5B0AB65A11D4BA460000459400000000 5B0AB65A11D4BA460000459400000000 B2D45E0211D550F10100D58698469B02 B2D45E0211D550F10100D58698469B02 ----------------------- sanpanico |
| All times are GMT +1. The time now is 01:01 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com