Forum Discussion
Edit Single Cell using power Query
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 |
Anonymous
Another way could be to use this custom column
=Text.Select([Column1],{"a".."z"}&{"A".."Z"})
2 Replies
Hi, Anonymous
TryColumn = 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] ))))
Anonymous
Another way could be to use this custom column
=Text.Select([Column1],{"a".."z"}&{"A".."Z"})
