Home

A letter to our Microsoft Project community

Highlighted
Deleted
Not applicable

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

@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 @Sergei Baklan 

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
35 Replies
Extentions Synchronization
ChirmyRam in Discussions on
3 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
9 Replies