How do I change my Phone format (1 Viewer)

[brodaman]

I want to convert my phone number format((234) 7038363294) to 2347038363292 thanks

 

[CJ_London]

probably easiest to use the replace function

newnum:replace(replace(replace(oldtxtnum,"(",""),")","")," ","")

not sure if it is a typo but the last number has changed

 

[brodaman]

probably easiest to use the replace function

newnum:replace(replace(replace(oldtxtnum,"(",""),")","")," ","")

not sure if it is a typo but the last number has changed

Please can you kindly buttress this replace function?

 

[CJ_London]

what does buttress mean?

 

[GohDiamond]

Replace Method: https://support.office.com/en-us/article/Replace-Function-6acf209b-01b7-4078-b4b8-e0a4ef67d181

Cheers!
Goh