Removing trailing text and formatting the column

[romachainani]

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!

[Felipe_Ribeir0]

Hi @romachainani 

Try this formula

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

[KamenRider]

Please see my solution using the text to column tool.

 

 

 

 

 

regards,

Kamen