STRIM

Thanks a lot!
From your argument description:
"space_removal_type: Required. Specifies the type of space removal and takes one of four arguments: "leading", removes leading spaces; "trailing", removes trailing spaces; "all", removes all spaces; "trim", removes all spaces except one space in between words"
No mention of middle spaces plus is mentioning "one of four arguments". That's why I did not do it in the first place. My bad that I did not follow your examples.

Anyhow, here is the function that does it all.
SPTRIM(ar,[ka]) calls ST
ar: any array containing any data type
[ka]: array of arguments or single values
- if ka omitted=> 0 => TRIM op
- if ka 1 => remove leading spaces
- if ka -1 => remove trailing spaces
- if ka 2 => remove middle spaces
- if ka=3 => remove all spaces


where ST:

Thanks much @Xlambda

Just got a chance to check back here as I was away all of last week. Your updated function works very well. I'll work on integrating it with STRIM hopefully during the coming week.

The helper function PLSA (and its components) in my STRIM just ensures that if the wrong type and/or number of parameter(s) are entered, the function returns a single #N/A (just like any native Excel function would do). This is to ensure that no erroneous output is generated by accident if the user mistakenly puts in the wrong argument or if the argument comes from another operation embedded in the parameter (the yellow/red highlights for SPTRIM vs. the green highlights for STRIM in the XL2BB below). (I put in entirely wrong arguments in the bottom table I always do that to my own functions to make sure that they crash with any wrong argument.)