Announcements
I have a string which may have a space any where.
e.g here : I have a space in the first character and in between words.
' foot ba ll'
I need a formulae to find, if any space exists in my string and remove all spaces if exists.
hi @dsab81 ,
try this :
Substitute(YourString," ","")
@Anonymous Before removing spaces, May i know how do i find, if there is any space in a string ?
Or
I need the count of spaces in a string.
CountRows(MatchAll("www.hot m a il .com", " "))
Above formula will count the number of occurrence of the character in a string. In this case. 4 Spaces.
@zmansuri Thanks. May i know the power automate equivalent of this formulae to get the count of spaces
Works perfectly @zmansuri . Thank you.
Hi @zmansuri Using the same formulae how can i get the count of upper case letters in a string ?
Please provide it here.
https://powerusers.microsoft.com/t5/Building-Flows/Count-of-Upper-Case-Letters-in-a-String/m-p/939837
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 396 Most Valuable Professional
11manish 134 Super User 2026 Season 2
MS.Ragavendar 101 Super User 2026 Season 2
