Forum Discussion
santu1021
Helper II
Helper IIremove 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 !!!!
bfernandez
Resolver II
Resolver IIYou 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:
santu1021Helper II
Helper IIThank 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
|
- bfernandez
Try this:
- santu1021
Thank you very much !!!!
- bfernandez
Glad I could help! Please mark the post as a solution to help others! 😁