Capitalization of cell upto first number

Using Power Query, load your file to PQ. Split the column based upon the delimeter "Non Digit to Digit." Upper Case the split column. Merge the columns back together. Here is the Mcode for that action

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Split Column by Character Transition" = Table.SplitColumn(Source, "Source", Splitter.SplitTextByCharacterTransition((c) => not List.Contains({"0".."9"}, c), {"0".."9"}), {"Source.1", "Source.2"}),
    #"Uppercased Text" = Table.TransformColumns(#"Split Column by Character Transition",{{"Source.1", Text.Upper, type text}}),
    #"Merged Columns" = Table.CombineColumns(#"Uppercased Text",{"Source.1", "Source.2"},Combiner.CombineTextByDelimiter("", QuoteStyle.None),"Merged")
in
    #"Merged Columns"

File attached for your review.