medium10 pts · first answer countsexceltext-functionsdata-cleaning

Removing commas from amounts

Amounts arrive as text like "1,25,000". Which formula turns A2 into the number 125000?

A.=TRIM(SUBSTITUTE(A2,","," "))B.=VALUE(SUBSTITUTE(A2,",",""))C.=VALUE(REPLACE(A2,",",""))D.=LEFT(A2,",")*1

Discussion 0

Join free to post in the discussion.