KhaledAHabib

NoNumbers = lambda(TextCell,TEXTJOIN("",FALSE,IF(ISNUMBER(MID(TextCell,SEQUENCE(1,LEN(TextCell)),1)*1),"",MID(TextCell,SEQUENCE(1,LEN(TextCell)),1))));
Reverse = LAMBDA(TextCell,TEXTJOIN("",FALSE,MID(TextCell,SEQUENCE(1,LEN(TextCell),LEN(TextCell),-1),1)));
PROPERSPACE = LAMBDA(Text, LET(TextUpper,MID(UPPER(Text),SEQUENCE(1,LEN(Text)),1),TextLower,MID(Text,SEQUENCE(1,LEN(Text)),1),TRIM(TEXTJOIN("",TRUE,IF(CODE(TextUpper)=CODE(TextLower),SUBSTITUTE(TextLower,TextLower," "&TextLower),TextLower)))));
Compare = LAMBDA(Range1,Range2,TEXTJOIN("|",TRUE,IF(Range1<>Range2,ADDRESS(ROW(Range2),COLUMN(Range2)),"")));
WordSearch = LAMBDA(STARTCELL,TARGETWORD,IF(OR(STARTCELL&""=LEFT(TARGETWORD),STARTCELL="?"),IF(LEN(TARGETWORD)=1,TRUE,OR(WordSearch(OFFSET(STARTCELL,-1,0),MID(TARGETWORD,2,LEN(TARGETWORD))),WordSearch(OFFSET(STARTCELL,1,0),MID(TARGETWORD,2,LEN(TARGETWORD))),WordSearch(OFFSET(STARTCELL,0,1),MID(TARGETWORD,2,LEN(TARGETWORD))),WordSearch(OFFSET(STARTCELL,0,-1),MID(TARGETWORD,2,LEN(TARGETWORD))),)),FALSE));
Hail