mediumCarsome · cleaningBasicNew
Clean a listing price into a usable number
Column A holds Carsome listing prices exported as text: an "RM " prefix, a thousands comma, and stray leading/trailing spaces from the export, e.g. " RM 45,900 ". Write formulas in B1:B2 that convert each listing into a plain number Excel can do arithmetic on.
Starting grid
A1
| A | B | |
|---|---|---|
| 1 | RM 45,900 | |
| 2 | RM 8,250 |
Basic
The expected output and walkthrough for this question unlock with a Basic plan.
Basic
The reference formulas and walkthrough for this question unlock with a Basic plan.
See Basic plansRM 25/mo · cancel anytime
Basic
This is a Basic question
Premium practice questions unlock with a Basic plan. The full solution, expected output, and grading are available to Basic members.
RM 25/mo · cancel anytime