Hi
I have immediate solution. I have 10+ years of experience in Excel & VBA. Please check my past reviews. I can provide you formula right now. Please ping back
Enter the text in A1 & Use the below formula in B1
=MID(A1,SEARCH("$",A1,1),LEN(A1)-SEARCH("$",A1,1))
Thank You
Regards
Rishi