Getting rid of empty cells

[tibor]

I have an address dataset that I'm trying to tiddy up. I have 5 addres
columns: addr1, addr2, addr3, addr4, addr5, where for some records
addr1 and addr2 are empty but addr3, addr4, and addr5 have data.
want to reposition the contents of addr3, addr4, and addr4 into addr1
addr2, and addr3 for that record. Is there a formula out there tha
would do this? Thanks!

 

[Ken Wright]

If you mean you want to shift all the data left into the blank cells, then
select the entire range, do edit / Go To / Special / Blank cells, then do Edit /
Delete / Shift Cells left

 

[Jason Morin]

1. Select your range.
2. Press F5 > Special.
3. Select "Blanks".
4. Press OK.
5. Press <Ctrl><->.
6. Select "Shift cells left".

HTH
Jason
Atlanta, GA