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...
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