3 Replies Latest reply: Jul 29, 2017 5:21 AM by Vineeth Pujari

Number Formatting - Telephone Number

Adrian Worrall Jul 28, 2017 3:43 PM

I have a telephone number in a list of contacts that I would like formatted as a phone number. The data includes international and mobile numbers. Does anyone have any ideas on how to make this look good? Many thanks

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) ?
Like Show 1 Like (1)

Actions
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
Like Show 1 Like (1)

Actions
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

How to get answers to your post?
Like Show 0 Likes (0)

Actions

Go to original post