I’ve got a column will all digits in the format of ##########. I would like to add a virtual column to reformat the numbers to ###-###-####. I am unclear as to what expression I need to input for the formula in the virtual column.
Solved! Go to Solution.
Please try
CONCATENATE(LEFT([InputNumber],3), “-”, MID([InputNumber],4,3), “-”, RIGHT([InputNumber],4))
Please take a look at
Please try
CONCATENATE(LEFT([InputNumber],3), “-”, MID([InputNumber],4,3), “-”, RIGHT([InputNumber],4))
Please take a look at
User | Count |
---|---|
40 | |
34 | |
29 | |
23 | |
17 |