substitute is a case sensitive function..

you can use the upper() lower() proper()

SUBSTITUTE(lower(A1:A3),$A$5,"")