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