How to remove a certain string form string text data?

Tetsuro_W
Tetsuro_W Partner, Registered Posts: 4 Partner

Hello experts, Please help me following question.

I have a string column like:

ABCDC01

ABCD02

ABCD03

AAAA

ABCD04

BBB

Now, I would like prepare to create a column copying above string, but I want to remove specific string "ABCD" thus expected data should be:

01

02

03

AAAA

04

BBB

How can I do this?

Thanks in advance.

Best Answer

Setup Info
    Tags
      Help me…