I need some help. Aim - If a user enters the first name in caps lock, I want a formula to keep the first letter as a capital and then the rest being lower case. (However there are some additional criteria which I need to add)
I have created the following formula (see below) which so far works. And does the following; daniel = Daniel DANIEL = Daniel
UPPER( LEFT(FirstName , 1) ) & LOWER( MID(FirstName , 2, LEN(FirstName ) ) )
However when testing I noticed that if you have a middle name then this also gets changes to lower case.
Desired results; DANIEL JOHN = Daniel John DANIEL = Daniel daniel = Daniel MCCLOUD = McCloud DANIEL-JOHN = Daniel-John
Object: Contact Field: First Name
EDIT
I have changed the formula to:
IF(FIND(" ",FirstName)>0, UPPER(LEFT(FirstName,1))+ MID(LOWER(FirstName), 2, FIND(" ",FirstName)-1)+ " " + UPPER(MID(FirstName, FIND(" ",FirstName)+1, 1))+ LOWER(MID(FirstName, FIND(" ",FirstName)+2, Len(FirstName)-FIND(" ",FirstName)+2)) ,UPPER(LEFT(FirstName,1))&Mid(LOWER(FirstName), 2, Len(FirstName)-1))
This resolves all the issues except for the McCloud scenario