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.....
Thank you very much !!!!
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:
Thank you very much !!!!