Formual to delete digit from text

[rizmomin]

Hello:
Please refer to attached file.

I need formula in cell C2 down to give me result as shown.
Let me know if you have any questions.
Thanks.

Riz

[Ron Coderre]

Using your posted workbook...and assuming the text always begins with 4 digits and a space...
This formula, copied down, returns the text you're looking for:

Please Login or Register  to view this content.

Is that something you can work with?

[rizmomin]

Hello ROn:

This should work.
Thanks

Riz