Phone Number Format

JLogan

Hi. I've trolled through pretty much every thread regarding this topic and I found a formula that works, except where it's not supposed to. I'm using this formula in a secondary cell/ column to format phone numbers in another column using parentheses and dashes. The problem I'm having is the formula converts the phone number in the cell/ column where the formula is and not where the phone number digits are stored. Please help, this is driving me crazy!!

="(" + LEFT([Contact Number]1, 3) + ") " + MID([Contact Number]1, 4, 3) + "-" + RIGHT([Contact Number]1, 4)

Thanks,

Jeremy

Maaik Meijerink

@JLogan,

It seems you want to change the cells in the column with the actuals numbers in it. If this is the case: it is not possible: you can only let the formula work based upon the other column, not within the source-column itself (where the original phone nu,mber digits are stored).

If you realy want this, you should use an API for solving your request.

If however misunderstood, please let me/community know.

Grtz, Maaik