remove suffix text......

[santu1021]

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

[bfernandez]

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:

[santu1021]

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

[bfernandez]

Try this:

[santu1021 · Accepted solution]

Thank you very much !!!!

[bfernandez]

Glad I could help! Please mark the post as a solution to help others! 😁