Replace part of a string with VBA

  • Hello,

    I'm working on a macro to partly delete strings like this : Mededeling: PAYCONIQ 6C328820EFFE1F7187A0762B FRITUUR DENISE Persoonlijke info: 6C328820EFFE1F7187A0762B

    There might be more varying text before the word "mededeling"

    The long alpha-numeric part appears twice every time but is otherwise unique.

    This part : FRITUUR DENISE Persoonlijke info: 6C328820EFFE1F7187A0762B should completely be deleted.

    I'm quite familiar with vba but this is a hard one for me. Thank you very much for helping me out .

    Herman

  • Possibly...

    If I've been helpful, let me know. If I haven't, let me know that too. 

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!