How do i Extract the first letter of each word of a 3 word string?
Do I somehow nest a Left() in a LeftWords() then Middle() - the same and Right() - the same?
I want to put a company name in a "Company" field and when I leave the field trigger the calculation to put the first letter of the first three words of the company field in the Company ID field.
Your help will be appreciated! Gary E Castle