From Tiny Earthworm, 3 Years ago, written in Plain Text.
This paste is a reply to Untitled from Scorching Hamster - go back
Embed
Viewing differences between Untitled and Re: Untitled
Extract $ amounts from string, excel

=TRIM(MID(C31,FIND("$",C31),IFERROR(FIND(" ",MID(C31,FIND("$",C31),LEN(C31))),LEN(C31))))=TRIM(MID(C31,FIND("$",C31),IFERROR(FIND(" ",MID(C31,FIND("$",C31),LEN(C31))),LEN(C31))))