I am trying to extract a substring with this formula

=Mid(D2,Find(“acct_num“,D2)+1,20)

and it is not working as intended.

The layout of the worksheet is
Number |Date |Name |Description

The description is variable in length so I cannot use left or right. Mid and Find seem to be the right formulas but I just cannot make them work together to find the substring.

Any ideas?