View original (French)

Formula to remove characters from a cell...

willaddict Posted messages 13 Status Membre -  
 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 réponses

Réponse 1 / 3
Vaucluse Posted messages 27336 Registration date   Status Contributeur 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
tontong Posted messages 2575 Registration date   Status Membre Last intervention   1 064
 
Hi,
I'm 3 minutes late again: I missed the train again!
0
Vaucluse Posted messages 27336 Registration date   Status Contributeur Last intervention   6 453
 
Hello Tontong
This is for all the times you've been early....!
Best regards
0
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
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