Remove blank spaces and make lower case
I would like to create a text formula that removes blank spaces and changes text to lower case. For example: [Field A] = New York City [new formula field] = newyorkcity thanks
Forum Discussion
I was looking for something similar and figured I'd post what worked for me. I used SearchAndReplace combined with Upper in my situation but you can use Lower.
SearchAndReplace(Lower([Field A]), " ", "")
Doing it this way does not require multiple Parts.
Here is the function reference I used.
------------------------------
Brandon Lopez
------------------------------