Can i change the number โ0โ to โ+โ for country code in phone number?
i appreciate any help
Solved! Go to Solution.
Never tried specifically this.
What about this:
CONCATENATE(
SUBSTITUTE(LEFT([phone],1),โ0โ,"+"),
MID([Phone],2,LEN([Phone])-1)
)
For reference:
EDIT: correction to expression
EDIT2: correction:
MID([Phone],2,LEN([Phone]-1)) ==> MID([Phone],2,LEN([Phone])-1)
You may want to use SUBSTITUTE():
Also, just in case, please have a look on this post:
Hi @Aurelien
The formula works, Iโve managed to change โ0โ to โ+โ, the problem is that everything with the number โ0โ changes, how do I change just the first number? Can you help me?
SUBSTITUTE([phone],โ0โ,"+")
what formula should i add?
Never tried specifically this.
What about this:
CONCATENATE(
SUBSTITUTE(LEFT([phone],1),โ0โ,"+"),
MID([Phone],2,LEN([Phone])-1)
)
For reference:
EDIT: correction to expression
EDIT2: correction:
MID([Phone],2,LEN([Phone]-1)) ==> MID([Phone],2,LEN([Phone])-1)
This is a misplaced parenthesis.
I corrected the expression above.
@alex_gibson011186 If you had checked at the documentation referenced provided, you would have noticed it
sorry I didnโt see it, thank you very much, now I can breathe easy
User | Count |
---|---|
41 | |
25 | |
25 | |
17 | |
12 |