Getting rid of empty cells

  • Thread starter Thread starter tibor
  • Start date Start date
T

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!
 
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
 
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
 
Back
Top