Phone Number Format

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

Find more posts tagged with

Accepted answers

All comments

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

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.