This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Ah - did not know about LEN and INDEX, thank you! I agree with you about
hard limits. My use case was an email address so I did it using the @ as
the string terminator: CONCATENATE(UPPER(LEFT([Email Address], 1)),
MID([Email Address], 2, FIND("@", [E...