View original (French)

Remove text from a cell and keep only the numbers.

Solved
JudithGuy Posted messages 6 Registration date   Status Membre Last intervention   -  
Rrradassse Posted messages 46 Status Membre -
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 réponses

Réponse 1 / 2
Fahora Posted messages 949 Status Membre 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
Fahora Posted messages 949 Status Membre 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
JudithGuy Posted messages 6 Registration date   Status Membre 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