Forum Discussion
Solved
remove suffix text......
Dear,
I have huge data with mixed of numbers and text. I want to remove all suffux text (like T,A, B etc) from the data. Suffix is not organised, some time only one Text, some time twice, 3 etc...
| As - Is | To be |
| A205T | A205 |
| A205TM | A205 |
| A220TP | A220 |
| A220TO | A220 |
| A300AU | A300 |
| A300AR | A300 |
| A300BFF | A300 |
| A300BGGH | A300 |
| A300BII | A300 |
| A300BRR | A300 |
| A300DS | A300 |
| A300DE | A300 |
| A300DF | A300 |
| A300DG | A300 |
| A300DH | A300 |
| A300DJ | A300 |
| A300EK | A300 |
| A300EQ | A300 |
| A770 | A770 |
| A770KO | A770 |
| A770AB | A770 |
| A770Gyy | A770 |
| A770Gk | A770 |
Santhosh
Thank you very much !!!!
5 Replies
You can accomplish this by going into Power Query and Extracting the first characters; which is your case seems to be the first 4 characters.
In Power Query:
Thank You !! I tired this option.
Sorry, the count is mixed, it is not organised, I don't how many different varient count I have in data.
CT2535KE - CT2535
E55A-E55
E45RTYU -E45
Try this:
