Removing trailing text and formatting the column

Question

I have these values in a column:

1233456 ABC-DEF

12349845863446 JKL-MNO

1234667 UVWWW-XYZ

3445767545

What I want the column to look like:

ABC123456

JKL12349845863446

UVWWW1234667

3445767545

Any help will be appreciated, thank  you!

KamenRider · Answer

Please see my solution using the text to column tool.

regards,

Kamen

Felipe_Ribeir0 · Answer

Hi @romachainani

Try this formula

REGEX_Replace(Input, '(\d+)\s?(\w+)?(\-\w+)?', '$2$1')

formula.yxmd