Home

A letter to our Microsoft Project community

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
30 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
7 Replies