In column A2 trying to remove trailing spaces , commas, the word USD and convert cell to number
How to merge the formulas below as one.
I have to do it in different cells
USD 11,269.44
expected RESULTS 11269.44
=SUBSTITUTE(TRIM(SUBSTITUTE(A2,",",""))," "," ")
=RIGHT(A2,LEN(A2)-3)
Bookmarks