View original (French)

Remove text from a cell and keep only the numbers.

Solved
JudithGuy Posted messages 6 Registration date   Status Member Last intervention   -  
Rrradassse Posted messages 46 Status Member -
Hello,

I know that it is possible through different means (LEFT/RIGHT/MID, etc.) to select only part of a cell, but... I can't do it! It always gives me an error in my formula.
Here it is: I have "Â 0833050937Â" in A1 and I would like to remove the "Â" to have just the phone number!
What formula should I insert?

Thank you in advance for your help :)

Configuration: Windows / Firefox 47.0

2 answers

  1.
    Fahora Posted messages 949 Status Member 68
     
    Hello,

    Do you only have Âs in your cells? Do they all consist in the same way?

    --
    Our only limits are those that we impose on ourselves.
    Politeness and a thank you won't kill you. There is a button for "Resolved" to confirm that your problem is no longer one. Fahora
    6
    1. Fahora Posted messages 949 Status Member 68
       
      If this is the case:

      =SUBSTITUTE(A1,"Â","")

      For "Â 0833050937Â" you get: " 0833050937"

      Otherwise the formula you are looking for with the MID function:
      =MID(A1,3,10)
      For "Â 0833050937Â" you get "0833050937"


      Note the space in front of the phone number.

      Best regards,
      1
    2. JudithGuy Posted messages 6 Registration date   Status Member Last intervention  
       
      Great, the two steps!
      Thank you very much :)

      And could you explain to me what the numbers 3 and 10 correspond to in the STXT formula? That's exactly what I couldn't grasp in the forums where I found this answer..
      0