Try this and drag down

=SUBSTITUTE(A1,"Z","")

Mike

"infinite1013" wrote:

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?