Antriksh5956
New Member
- Joined
- Sep 28, 2017
- Messages
- 1
I have this formula and i know what it does but i am not able to understand how it works.
=TRIM(RIGHT(SUBSTITUTE(TRIM(A1)," ",REPT(" ",255)),255))
i am confused as how this formula works and what is the role of "255" in this ?
Thank You!
=TRIM(RIGHT(SUBSTITUTE(TRIM(A1)," ",REPT(" ",255)),255))
i am confused as how this formula works and what is the role of "255" in this ?
Thank You!