Forum Discussion
A letter to our Microsoft Project community
Can you please help me to create a Formula, I get an error every time I try to add the one that i had =UPPER(LEFT(A9,1*MID(A9,FIND(".",A9)+1,LEN(A9)-FIND(".",A9)))) I attach the file, =LEFT...
If you want to extract all characters after the dot (.), then convert them to uppercase, this is the formula you need:
=UPPER(RIGHT(A9,
LEN(A9)-FIND(“.”,A9)))
=UPPER(RIGHT(A9,
LEN(A9)-FIND(“.”,A9)))