I have a field on which I need a calculated value output in the following formats:
Textfield 1 TextField1 Calc
Laurel Crest LC
Laurel Crest 1 LC1
Laurel Crest 2 LC2
Bella Vista BC
I need someone to teach me how to obtain an effective formula to grab the first letter of Textfield1 when textfield1 is equal to one word. I also need the formula to grab the first letter of the the first word and the first letter of the second word when textfield1 equals two words.
last, I need the formula to grab the first letter of the first word, the first letter of the the second word, and the number of the thrid word..... Rudy,