Remove certain characters from the end of a string only

Please make your sample data in an excel file and attach it since unable to identify which one is the separator whether dot or =>.

if you do in fact have .. in the middle of the text string, use this...
=IF(RIGHT(A1,1)=".",LEFT(A1,LEN(A1)-1),A1)

if the .. was just something you put into the data here (to show missing info?), then use =SUBSTITUTE(A1,".","")

Or in B2 - Array Formula - Requires Ctrl+Shift+Enter

Formula:

=IFERROR(MID($A2,1,(LEN($A2)+1)-MATCH(TRUE,(MID($A2,(LEN($A2)+1)-ROW(INDIRECT("1:"&LEN($A2))),1)=".")=(MID($A2,(LEN($A2)+1)-ROW(INDIRECT("1:"&LEN($A2))),1)=CHAR(133)),0)),"")

Drag it down

If you don't mind a UDF solution, check the attachment

Hope this helps

oops,my bad..
copy this

Function FindLastAlpha(StrVal As String, Optional StrtPos, Optional IncludeNums, Optional IncludeSpace) As Long
    Dim LCount As Long
    Const AlphaStr As String = "[A-Z]"
    Const NumStr As String = "[0-9]"
    If IsMissing(StrtPos) Then StrtPos = 1
    If IsMissing(IncludeNums) Then IncludeNums = False
    If IsMissing(IncludeSpace) Then IncludeSpace = False
    FindLastAlpha = 0
    If StrtPos > Len(StrVal) Then Exit Function
    If Len(StrVal) = 0 Then Exit Function
    For LCount = 0 + StrtPos To Len(StrVal)
        If UCase(Mid(StrVal, LCount, 1)) Like AlphaStr Then
            FindLastAlpha = LCount
        ElseIf IncludeNums And (Mid(StrVal, LCount, 1) Like NumStr) Then
            FindLastAlpha = LCount
        ElseIf IncludeSpace And (Mid(StrVal, LCount, 1) = " ") Then
            FindLastAlpha = LCount
        End If
    Next
End Function

then in the new workbook, open the VBA editor (<alt> +<F11>)
Insert ->Module - paste
save, close the editor and use

Edit-
when you save, it will probably tell you the workbook is not macro enabled, so you will have to Save As, Excel Macro-Enabled Workbook

You are very welcome

see if the attached helps...

create a Defined Name (ALT > M > N) called "midtxt" (without the quotes). this assumes your data are in column A and no value is longer than 25 characters (you can change this if you need to).

=MID(UPPER(Sheet1!$A1),ROW(Sheet1!$1:$25),1)

then, place this formula in cell B1 (or wherever else your input data start, and update cell references accordingly), ARRAY-confirm and drag-fill down:

=LEFT($A1,MAX(IFERROR((((CODE(midtxt)>=48)*(CODE(midtxt)<=57))+((CODE(midtxt)>=65)*(CODE(midtxt)<=90)))*ROW($1:$25),0)))

UPDATE:

slightly shorter version of the formula in B1:

=LEFT($A1,MAX(IFERROR((((CODE(midtxt)>=65)*(CODE(midtxt)<=90))+ISNUMBER(VALUE(midtxt)))*ROW($1:$25),0)))