Mar 21 2019 02:51 AM
Mar 21 2019 02:51 AM
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!
Mar 21 2019 12:34 PM
Mar 21 2019 01:17 PM - edited Mar 21 2019 01:22 PM
@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.
Mar 24 2019 05:44 PM
thanks for the support, I will try @Sergei Baklan