How to remove a certain string form string text data?

Tetsuro_W

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.

Tetsuro_W

Sorry, I found the answer; it was replace (column1, "ABCD", "") .