This content has been marked as final.
Show 3 replies
-
Re: Number Formatting - Telephone Number
omar bensalem Jul 28, 2017 6:51 PM (in response to Adrian Worrall)Can you give us a sample of what you have and what you want to have (the output) ?
-
Re: Number Formatting - Telephone Number
Tomasz Truszkowski Jul 29, 2017 2:08 AM (in response to Adrian Worrall)If the data is clean, you can use string concatenation and left(), mid(), right() functions. If not, maybe purgechar() could help.
Tomasz
-
Re: Number Formatting - Telephone Number
Vineeth Pujari Jul 29, 2017 5:21 AM (in response to Adrian Worrall)we can't see what you are looking at; providing a sample will let the people here help you better