View original (French)

Formula to remove characters from a cell...

willaddict Posted messages 13 Status Member -  
 Boumboum -
Hello everyone,

I am desperately looking for a way to remove characters (the dashes) in a cell as follows:

Departure: xxx-xxxx-xxx
Arrival: xxxxxxxxxx

Thank you all

Willy

3 answers

  1.
    Vaucluse Posted messages 27336 Registration date   Status Contributor Last intervention   6 453
     
    Hello

    in formula:

    =SUBSTITUTE(A1,"-","")

    or via the replace
    __ select the field
    __ press ctrl and h
    __ in the top box enter the dash
    __ in the bottom box enter nothing
    __ click on "replace all"

    cheers

    --
    To err is human, to persist is diabolical
    21
    1. tontong Posted messages 2575 Registration date   Status Member Last intervention   1 064
       
      Hi,
      I'm 3 minutes late again: I missed the train again!
      0
    2. Vaucluse Posted messages 27336 Registration date   Status Contributor Last intervention   6 453
       
      Hello Tontong
      This is for all the times you've been early....!
      Best regards
      0
    3. Boumboum
       
      Cool but I can't remove the quotes with this formula (I only want to do it with a formula, not by search/replace).
      0
      1. Boumboum > Boumboum
         
        Well, I found it; you have to put two quotes, so it gives => =SUBSTITUTE(A1,"""","")
        It's a bit weird, but that's how it is.
        0