Remove Text from a number

I have a column of numbers formatted like this $-175.15 USD. How to total the column and remove the USD ?

isnoend2001Asked:
Who is Participating?
 
zorvek (Kevin Jones)ConsultantCommented:
A different formula that does not require special entry:

   =SUMPRODUCT(VALUE(SUBSTITUTE(SUBSTITUTE(A1:A2," USD",""),"$","")))

Kevin
0
 
zorvek (Kevin Jones)ConsultantCommented:
You can use the Replace command. Select the cells to edit, press CTRL+H, enter " USD" in the Find field and leave the replace field empty. Replace all.

Kevin
0
 
zorvek (Kevin Jones)ConsultantCommented:
You can also use this formula to add the values WITHOUT first removing the USD and $:

   =SUM(VALUE(SUBSTITUTE(SUBSTITUTE(A1:A2," USD",""),"$","")))

Enter the formula by pressing CTRL+SHIFT+ENTER.

Kevin
0
 
isnoend2001Author Commented:
Thank you
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.