Remove numbers from alphanumeric from a cells and display only Text

[sobinp]

My Loaded sheet in the power query has data given as input in the below example I need formula to convert the data to another sheet by removing any thing other than alphabet from a cell and display it

Note : The input might contain Number, Special character or spaces before the actual text.


for example


Input


1. Toyota
2. Ford
3. Nissan
Toyota
Honda
4. Fiat

Output


Toyota
Ford
Nissan
Toyota
Honda
Fiat

 

[sandy666]

is that what you want?

[Table="width:, class:head"]
[tr=bgcolor:#FFFFFF][td=bgcolor:#5B9BD5]raw data[/td][td][/td][td=bgcolor:#70AD47]Names[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#DDEBF7]1. Toyota[/td][td][/td][td=bgcolor:#E2EFDA]Toyota[/td][/tr]

[tr=bgcolor:#FFFFFF][td]2. Ford[/td][td][/td][td]Ford[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#DDEBF7]3. Nissan[/td][td][/td][td=bgcolor:#E2EFDA]Nissan[/td][/tr]

[tr=bgcolor:#FFFFFF][td]Toyota[/td][td][/td][td]Toyota[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#DDEBF7]Honda[/td][td][/td][td=bgcolor:#E2EFDA]Honda[/td][/tr]

[tr=bgcolor:#FFFFFF][td]4. Fiat[/td][td][/td][td]Fiat[/td][/tr]
[/table]

[SIZE=1]let
    C2R = List.Transform({32..64,91..96,123..126}, each Character.FromNumber(_)),
    Source = Excel.CurrentWorkbook(){[Name="Table3"]}[Content],
    Names = Table.AddColumn(Source, "Names", each Text.Trim([raw data],C2R)),
    ROC = Table.SelectColumns(Names,{"Names"})

in
    ROC[/SIZE]