How can I Capitalize each word and remove all special characters and then combine all words in Excel?

I have an Excel sheet with 500 values in column A. I am looking for a formula to Capitalize each word and remove all special characters and then combine all words.

Text in Column A: Vision, mission, values/text and approach

Desired Output: VisionMissionValuestTextAndApproach

>Solution :

Use REDUCE and LAMBDA and SUBSTITUTE:

=SUBSTITUTE(PROPER(REDUCE(A1,{",","/"},LAMBDA(a,b,SUBSTITUTE(a,b," "))))," ","")

Adding to the array any other characters needing removal.