Google sheets formula to remove currency sign

user_311130 0
Viewed 98

Which formula can I use to remove the currency sign?

Anything smarter than: REPLACE(value,0,1)?

google-sheets-formula google-sheets
2 Answers

Your question is way too vague.

Having said that, let's cover different conditions

  • Cell as TEXT =C1*1
  • Cell as NUMBER =N(C2)
  • Raw Value =("$-123.55")*1

enter image description here

user_15277800

Try the following

=SUBSTITUTE(value, "$", "")

user_157844150
Related