bebermanii
New Member
- Joined
- Sep 25, 2002
- Messages
- 6
I need an easy way to get rid of MANY blank cells that are scattered throughout the range (M2:CI132). Each row has at least one cell that contains data, but that one cell may be in column AA and the cells from column M to Z in that row would need to be deleted. Most rows have multiple cells containing data that also have blank cells inbetween them and all of those need to be deleted as well. The goal is to have all of the data lined up on the left starting in column M and continuing to the right with no blanks inbetween the data.