I'm not sure how the strings look like, but you could try something like this to convert:
IF CONTAINS([A],"$") THEN FLOAT(REPLACE([A],"$",""))
ELSEIF CONTAINS([A],"%") THEN FLOAT(REPLACE([A],"%",""))/100
If that doesn't match the requirement, please edit the attached file
to more closely match your true datasource.
Please see workbook v10.3 attached in the Forum Thread:
Thank you for this!
I did not think to make these converted columns and then can just hide them so only the rows before the conversion show. Thanks so much!