ACRONYM

ACRONYM(text, just_capitals)
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=_xldudf_JS_ID4_ACRONYM("Microsoft Office Add- ins") = #NAME?
2=_xldudf_JS_ID4_ACRONYM("Rapid Application Development") = #NAME?
3=_xldudf_JS_ID4_ACRONYM("By The Way") = #NAME?
4=_xldudf_JS_ID4_ACRONYM("National Society for the Prevention of Cruelty to Children") = #NAME?
5=_xldudf_JS_ID4_ACRONYM("National Society for the Prevention of Cruelty to Children", TRUE) = #NAME?

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.



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