Extract $ amounts from string, excel =TRIM(MID(C31,FIND("$",C31),IFERROR(FIND(" ",MID(C31,FIND("$",C31),LEN(C31))),LEN(C31))))