I have a column of text that I need to remove one letter from. The cells are
formatted like this- AT&T DF ZS017 46336. I need to remove the Z. I would go
through and do them individually, but there are about 16,000 of them. Is
there a formula that will do this?