ACRONYM

Returns the first letter of each word.

textThe text you want the acronym for.
just_capitals(Optional) Whether to only use the words that have capital letters.

Remarks

* The "text" can be a cell range.
* If "just_capitals" is left blank, then False is used.
* The equivalent VBA function is ACRONYM

 A
1=JS.ACRONYM("Microsoft Office Add-ins")
2=JS.ACRONYM("Rapid Application Development")
3=JS.ACRONYM("By The Way")
4=JS.ACRONYM("National Society for the Prevention of Cruelty to Children")
5=JS.ACRONYM("National Society for the Prevention of Cruelty to Children",TRUE)

1 - What is the acronym of "Microsoft Office Add-ins".
2 - What is the acronym of "Rapid Application Development".
3 - What is the acronym of "By The Way".
4 - What is the acronym of "National Society for the Prevention of Cruelty to Children".
5 - What is the acronym of "National Society for the Prevention of Cruelty to Children" only including capital letters.


alt text

© 2022 Better Solutions Limited. All Rights Reserved. © 2022 Better Solutions Limited TopPrevNext