Hey, I am trying to create a macro that will remove numbers in one column from different sheets but leave the text that is in there. It will be six different sheets and the total numbers in the columns fluctuate throughout the day. I need a way for it to clear the data without clearing the text. I have gotten something but it clears the text as well. Thank you for your help!