Edit Single Cell using power Query

[Anonymous]

I am trying to edit the data (individual cells)through Power query.
I need a forumla to convert the table below .

for example

Input                                                        

1. Toyota

2. Ford

3. Nissan

Toyota

Honda

4. Fiat

Output

Toyota

Ford

Nissan

Toyota

Honda

Fiat

[EugenioJunior]

Hi, @Anonymous 

Try 

Column = 
IF(table[column] = "1. Toyota", "Toyota",
IF(table[column] = "2. Ford", "Ford",
IF(table[column] = "3. Nissan", "Nissan",
IF(table[column] = "4. Fiat", "Fiat", table[column] ))))

[Zubair_Muhammad · Accepted solution]

@Anonymous 

Another way could be to use this custom column

=Text.Select([Column1],{"a".."z"}&{"A".."Z"})