How to remove semicolon character with excel

Asked

Viewed 17,620 times

5

I am trying to use an excel formula to remove the semicolon, but even with the correct formula line I am not able to solve. What I got now is this:

=SUBSTITUIR(SUBSTITUIR(K2;".";"");",00";"")

I’m trying to replace the values that are like this: 2.000,00 for 2000 so that the entire column is modified, but the value is 0,00

A picture of the column.

inserir a descrição da imagem aqui

excel
  • 2

    That point you’re seeing in the column doesn’t exist. Excel shows the content this way after formatting, so you can’t replace it.

  • 1

    Format the column as GENERAL

2 answers

3


Use the formula TEXTO to reconfigure the formatting of numbers. Since you want to remove the dots (thousand separators) and commas (decimal places), your formula will look like this:

=TEXTO(K2;"0")

...or, if you do not wish to hide the decimal places other than 0:

=TEXTO(K2;"Geral")

In your case, SUBSTITUIR only works when you’re dealing with texts yourself!

  • 1

    Thanks for the help @Tash_riser, made it very easy.

1

Change the cell formatting to remove the thousand separator and reduce the number of decimal places to zero.

Formatação de células

Browser other questions tagged excel

You are not signed in. Login or sign up in order to post.