Not sure how to take for example 2167752324 and format as (216)775-2324.
Are you familiar with EasyMorph expressions / functions? You can achieve this by using the “Modify Column(s)” action and building an expression that uses the following functions:
- LEFT: syntax:functions:left [EasyMorph Help]
- MID: syntax:functions:mid [EasyMorph Help]
- RIGHT: syntax:functions:right [EasyMorph Help]
And then concatenating everything (using &) and also adding the parenthesis/dash in the concatenation.
Let me know if you need more detail.