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(A8,1)
=MID(A8,FIND(".",A8)+1,LEN(A8)-FIND(".",A8))
=UPPER(CONCATENATE(B8,C8,D8,))
if I just the formula I don't need to concatenate
=UPPER(LEFT(A9,1*MID(A9,FIND(".",A9)+1,LEN(A9)-FIND(".",A9))))
But I get an error #VALUE!
3 Replies
Deleted , the #VALUE error is returned since you multiply number 1 on the text returned by MID(). I guess that was misprint, you don't need that.
In addition to the formula Twifoo suggested you may use Data->Text to Columns or Flash Fill, depends on needs.
thanks for the support, I will try SergeiBaklan
- 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)))
