Can textbox value be converted from "Alpha Bravo Charlie" to "ABC"?

[jcrist30]

I am wondering if there is a way to convert the value of a text box to an acronym represented by the first letter of each word in the textbox.

i.e. User would input "Alpha Bravo Charlie" and this could be converted elsewhere to "ABC".

Any help would be great! :)

[Rabbit]

Use VBA to SPLIT() the string by spaces and take the LEFT() one character from each word.

[NeoPa]

Certainly I know of no way to handle this in a single step unless a procedure is written for the purpose. Rabbit's suggestion seems as good as you'll get.

[Mihail]

Or collect only the capitals.

[NeoPa]

Don't confuse the example with the question Mihail. We only know for sure that the initials are required, not that the initials will always be capitalised ;-)

[Mihail]

Correct, NeoPa.
So my vote is for Rabbit too :)