{"id":2518,"date":"2022-04-04T13:00:00","date_gmt":"2022-04-04T12:00:00","guid":{"rendered":"https:\/\/firetext.wpengine.com\/?p=2518"},"modified":"2024-07-30T10:55:44","modified_gmt":"2024-07-30T09:55:44","slug":"how-to-format-mobile-phone-numbers-in-excel","status":"publish","type":"post","link":"https:\/\/www.firetext.co.uk\/blog\/how-to-format-mobile-phone-numbers-in-excel\/","title":{"rendered":"How to format mobile phone numbers in Excel"},"content":{"rendered":"\n<p>Follow our three-step guide to excel-lently format your phone numbers. This is super useful for when you\u2019re uploading your contacts into FireText&#8217;s SMS platform from a CSV file. <\/p>\n\n\n\n<!--more-->\n\n\n\n<h4 class=\"pink\">Step 1: Clear out the data you don\u2019t need<\/h4>\n\n\n\n<p>Firstly, remove anything from your spreadsheet that you don\u2019t want to be uploaded into the FireText platform.<\/p>\n\n\n\n<p>If you\u2019re doing this, be sure to actually \u2018delete\u2019 columns instead of simply hiding them. And if you&#8217;re removing unnecessary information ready to upload to FireText, always keep a backup file!<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"400\" src=\"https:\/\/firetext.wpengine.com\/wp-content\/uploads\/2022\/04\/How-to-Format-Mobile-Numbers-in-Excel.png\" alt=\"\" class=\"wp-image-3879\" srcset=\"https:\/\/www.firetext.co.uk\/blog\/wp-content\/uploads\/2022\/04\/How-to-Format-Mobile-Numbers-in-Excel.png 800w, https:\/\/www.firetext.co.uk\/blog\/wp-content\/uploads\/2022\/04\/How-to-Format-Mobile-Numbers-in-Excel-300x150.png 300w, https:\/\/www.firetext.co.uk\/blog\/wp-content\/uploads\/2022\/04\/How-to-Format-Mobile-Numbers-in-Excel-768x384.png 768w\" sizes=\"auto, (max-width: 800px) 100vw, 800px\" \/><\/figure>\n\n\n\n<div style=\"height:28px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h4 class=\"pink\">Step 2: Place your data in the columns<\/h4>\n\n\n\n<p>You have the option to upload your recipients&#8217; name, number and 3 custom fields.<\/p>\n\n\n\n<p>You can pick and choose from these options which data you would like to upload, but obviously mobile numbers are essential.<\/p>\n\n\n\n<p>If you only want to upload numbers, that\u2019s absolutely fine. Just like the example below.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"400\" src=\"https:\/\/firetext.wpengine.com\/wp-content\/uploads\/2022\/03\/Example-list-of-phone-numbers-in-Excel.png\" alt=\"\" class=\"wp-image-3866\" srcset=\"https:\/\/www.firetext.co.uk\/blog\/wp-content\/uploads\/2022\/03\/Example-list-of-phone-numbers-in-Excel.png 800w, https:\/\/www.firetext.co.uk\/blog\/wp-content\/uploads\/2022\/03\/Example-list-of-phone-numbers-in-Excel-300x150.png 300w, https:\/\/www.firetext.co.uk\/blog\/wp-content\/uploads\/2022\/03\/Example-list-of-phone-numbers-in-Excel-768x384.png 768w\" sizes=\"auto, (max-width: 800px) 100vw, 800px\" \/><\/figure>\n\n\n\n<div style=\"height:10px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h4 class=\"pink\">Step 3: Format your phone numbers correctly<\/h4>\n\n\n\n<p>When saving an Excel document as a CSV file, it will save it exactly how it looks.<\/p>\n\n\n\n<p>Although Excel is great with numbers, when it comes to phone numbers it tends to struggle and will often shorten it &#8211; so you may see an E+10 or E+11 at the end. <\/p>\n\n\n\n<p>Because this is how the CSV will save it, the FireText platform is clever enough to detect that these numbers aren&#8217;t correct &#8211; preventing you from uploading them.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"400\" src=\"https:\/\/firetext.wpengine.com\/wp-content\/uploads\/2022\/03\/Different-mobile-number-formats-in-Excel.png\" alt=\"\" class=\"wp-image-3867\" srcset=\"https:\/\/www.firetext.co.uk\/blog\/wp-content\/uploads\/2022\/03\/Different-mobile-number-formats-in-Excel.png 800w, https:\/\/www.firetext.co.uk\/blog\/wp-content\/uploads\/2022\/03\/Different-mobile-number-formats-in-Excel-300x150.png 300w, https:\/\/www.firetext.co.uk\/blog\/wp-content\/uploads\/2022\/03\/Different-mobile-number-formats-in-Excel-768x384.png 768w\" sizes=\"auto, (max-width: 800px) 100vw, 800px\" \/><\/figure>\n\n\n\n<div style=\"height:10px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>So you need to ensure that the numbers are formatted correctly. To do this:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Select the column with your numbers in it and right-click, then select \u2018Format Cells\u2019.<\/li>\n\n\n\n<li>You will see a pop-up box, with several options down the left-hand side &#8211; you want to hit the \u2018Number\u2019 tab.<\/li>\n\n\n\n<li>Then where it says \u2018Decimal places\u2019, you want to set this to 0. As soon as you hit \u2018OK\u2019 your numbers will all be formatted correctly and ready to go.<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"alignleft size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"700\" src=\"https:\/\/firetext.wpengine.com\/wp-content\/uploads\/2022\/03\/How-to-correctly-format-mobile-numbers-in-Excel.png\" alt=\"\" class=\"wp-image-3869\" srcset=\"https:\/\/www.firetext.co.uk\/blog\/wp-content\/uploads\/2022\/03\/How-to-correctly-format-mobile-numbers-in-Excel.png 800w, https:\/\/www.firetext.co.uk\/blog\/wp-content\/uploads\/2022\/03\/How-to-correctly-format-mobile-numbers-in-Excel-300x263.png 300w, https:\/\/www.firetext.co.uk\/blog\/wp-content\/uploads\/2022\/03\/How-to-correctly-format-mobile-numbers-in-Excel-768x672.png 768w\" sizes=\"auto, (max-width: 800px) 100vw, 800px\" \/><\/figure>\n<\/div>\n\n\n<div style=\"height:10px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h4 class=\"pink\">Now you&#8217;re ready to upload your contacts!<\/h4>\n\n\n\n<p>Once those final checks are done and you\u2019re all ready to save, simply select &#8216;save as&#8217; and hit the \u2018CSV (Comma delimited) (*.csv)\u2019 option.<\/p>\n\n\n\n<p>Now you\u2019re ready to upload them into the platform &#8211; and we have an <a href=\"https:\/\/help.firetext.co.uk\/hc\/en-gb\/articles\/360000079931-Uploading-Contacts\" data-type=\"URL\" data-id=\"https:\/\/help.firetext.co.uk\/hc\/en-gb\/articles\/360000079931-Uploading-Contacts\">awesome guide to uploading contacts<\/a> that will explain step by step how to do this.<\/p>\n\n\n\n<p><strong>Sending to international numbers?<\/strong> Your FireText account is set up as default to send to UK numbers only. If you have an <a href=\"https:\/\/help.firetext.co.uk\/hc\/en-gb\/articles\/360000054411-Can-I-send-SMS-internationally-\" target=\"_blank\" rel=\"noreferrer noopener\">international account enabled<\/a> with us, follow our formatting guidance <a href=\"#international-format\" data-type=\"internal\" data-id=\"#international-format\">below.<\/a><\/p>\n\n\n\n<h2 class=\"grey\">Key considerations when uploading to FireText<\/h2>\n\n\n\n<div style=\"height:10px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h4 class=\"pink\">The platform is pretty flexible with formatting<\/h4>\n\n\n\n<p>As a note, excel may remove the first \u20180\u2019. Don\u2019t panic if this happens as the FireText platform can recognise any numbers uploaded in the format of 07<strong><em>, 447<\/em><\/strong> or just 7***.<\/p>\n\n\n\n<p>The system will also remove any spaces, or other characters too. (This includes the \u2018+\u2019 in \u2018+44\u2019) So, if you have a hyphen or even some of the numbers in brackets, the platform will still upload these as numbers.<\/p>\n\n\n\n<h4 class=\"pink\">One Excel sheet does plenty<\/h4>\n\n\n\n<p>A few last things to double-check is the number of sheets on your document. Ideally, you only want one. However, if there is more than one, you need to make sure it\u2019s the first tab.<\/p>\n\n\n\n<h2 id=\"international-format\" class=\"grey\">Sending internationally: converting numbers<\/h2>\n\n\n\n<p>As default, FireText accounts are set to send to UK numbers only. If do you have an <a href=\"https:\/\/help.firetext.co.uk\/hc\/en-gb\/articles\/360000054411-Can-I-send-SMS-internationally-\" target=\"_blank\" rel=\"noreferrer noopener\">international account<\/a> enabled with us, you need to make sure all of your numbers begin with the right area code.<\/p>\n\n\n\n<p>This is important. You\u2019ll notice that when you enter your numbers into an Excel spreadsheet, Excel automatically removes the first zero. For a UK account, this isn\u2019t a problem, as FireText will still count them as a valid mobile number.<\/p>\n\n\n\n<p>However, an international account will count these as Russian mobile numbers (which begin with 7) if we don\u2019t format them first.<\/p>\n\n\n\n<p>We\u2019ve got an easy formula you can apply to your spreadsheet.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Make sure that all mobile numbers are running down one column<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"500\" src=\"https:\/\/firetext.wpengine.com\/wp-content\/uploads\/2022\/03\/Step-1-formatting-international-phone-numbers.png\" alt=\"\" class=\"wp-image-3871\" srcset=\"https:\/\/www.firetext.co.uk\/blog\/wp-content\/uploads\/2022\/03\/Step-1-formatting-international-phone-numbers.png 800w, https:\/\/www.firetext.co.uk\/blog\/wp-content\/uploads\/2022\/03\/Step-1-formatting-international-phone-numbers-300x188.png 300w, https:\/\/www.firetext.co.uk\/blog\/wp-content\/uploads\/2022\/03\/Step-1-formatting-international-phone-numbers-768x480.png 768w\" sizes=\"auto, (max-width: 800px) 100vw, 800px\" \/><\/figure>\n\n\n\n<div style=\"height:10px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Click the blank box in the column right of the first number (if you have more data alongside this, right-click the entire column and select \u2018insert column to the right\u2019).<\/li>\n\n\n\n<li>In this blank box enter =CONCATENATE(44,A1) and hit enter<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"500\" src=\"https:\/\/firetext.wpengine.com\/wp-content\/uploads\/2022\/03\/Step-2-formatting-international-phone-numbers.png\" alt=\"\" class=\"wp-image-3872\" srcset=\"https:\/\/www.firetext.co.uk\/blog\/wp-content\/uploads\/2022\/03\/Step-2-formatting-international-phone-numbers.png 800w, https:\/\/www.firetext.co.uk\/blog\/wp-content\/uploads\/2022\/03\/Step-2-formatting-international-phone-numbers-300x188.png 300w, https:\/\/www.firetext.co.uk\/blog\/wp-content\/uploads\/2022\/03\/Step-2-formatting-international-phone-numbers-768x480.png 768w\" sizes=\"auto, (max-width: 800px) 100vw, 800px\" \/><\/figure>\n\n\n\n<div style=\"height:10px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Grab the corner of this box and drag down throughout all of the numbers going down the original column<\/li>\n\n\n\n<li>This will fill the new column with all of the mobile numbers, now including the 44 country code in front of them<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"500\" src=\"https:\/\/firetext.wpengine.com\/wp-content\/uploads\/2022\/03\/Step-3-formatting-international-phone-numbers.png\" alt=\"\" class=\"wp-image-3873\" srcset=\"https:\/\/www.firetext.co.uk\/blog\/wp-content\/uploads\/2022\/03\/Step-3-formatting-international-phone-numbers.png 800w, https:\/\/www.firetext.co.uk\/blog\/wp-content\/uploads\/2022\/03\/Step-3-formatting-international-phone-numbers-300x188.png 300w, https:\/\/www.firetext.co.uk\/blog\/wp-content\/uploads\/2022\/03\/Step-3-formatting-international-phone-numbers-768x480.png 768w\" sizes=\"auto, (max-width: 800px) 100vw, 800px\" \/><\/figure>\n\n\n\n<div style=\"height:10px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Now copy this column and paste the values (paste special &gt;&gt; values) over the old column<\/li>\n\n\n\n<li>Save the file in a CSV format and you\u2019re ready to upload your contacts to FireText!<\/li>\n<\/ul>\n\n\n\n<p>Now you&#8217;re ready to craft your message and send out to your contacts. For top tips, check out our <a href=\"https:\/\/www.firetext.co.uk\/sms-marketing\" data-type=\"URL\" data-id=\"https:\/\/www.firetext.co.uk\/sms-marketing\">ultimate guide<\/a> to SMS marketing.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Follow our three-step guide to excel-lently format your phone numbers. This is super useful for when you\u2019re uploading your contacts into FireText&#8217;s SMS platform from a CSV file.<\/p>\n","protected":false},"author":11,"featured_media":3890,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[37],"tags":[],"class_list":["post-2518","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-how-to"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.6 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to format mobile phone numbers in Excel - SMS Marketing Blog<\/title>\n<meta name=\"description\" content=\"Excel at formatting your phone numbers in Excel. Follow our quick and easy three-step guide to get your numbers looking nice.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.firetext.co.uk\/blog\/how-to-format-mobile-phone-numbers-in-excel\/\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to format mobile phone numbers in Excel - SMS Marketing Blog\" \/>\n<meta property=\"og:description\" content=\"Excel at formatting your phone numbers in Excel. Follow our quick and easy three-step guide to get your numbers looking nice.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.firetext.co.uk\/blog\/how-to-format-mobile-phone-numbers-in-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"SMS Marketing Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/firetext.co.uk\/\" \/>\n<meta property=\"article:published_time\" content=\"2022-04-04T12:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-07-30T09:55:44+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.firetext.co.uk\/blog\/wp-content\/uploads\/2022\/04\/how-to-format-numbers-in-excel-featured-image.png\" \/>\n\t<meta property=\"og:image:width\" content=\"400\" \/>\n\t<meta property=\"og:image:height\" content=\"320\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Megan Parker\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@firetext_uk\" \/>\n<meta name=\"twitter:site\" content=\"@firetext_uk\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Megan Parker\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.firetext.co.uk\/blog\/how-to-format-mobile-phone-numbers-in-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.firetext.co.uk\/blog\/how-to-format-mobile-phone-numbers-in-excel\/\"},\"author\":{\"name\":\"Megan Parker\",\"@id\":\"https:\/\/www.firetext.co.uk\/blog\/#\/schema\/person\/272c184e80b2a6fa926acaa2c42cb0dd\"},\"headline\":\"How to format mobile phone numbers in Excel\",\"datePublished\":\"2022-04-04T12:00:00+00:00\",\"dateModified\":\"2024-07-30T09:55:44+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.firetext.co.uk\/blog\/how-to-format-mobile-phone-numbers-in-excel\/\"},\"wordCount\":794,\"publisher\":{\"@id\":\"https:\/\/www.firetext.co.uk\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.firetext.co.uk\/blog\/how-to-format-mobile-phone-numbers-in-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.firetext.co.uk\/blog\/wp-content\/uploads\/2022\/04\/how-to-format-numbers-in-excel-featured-image.png\",\"articleSection\":[\"How To\"],\"inLanguage\":\"en-GB\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.firetext.co.uk\/blog\/how-to-format-mobile-phone-numbers-in-excel\/\",\"url\":\"https:\/\/www.firetext.co.uk\/blog\/how-to-format-mobile-phone-numbers-in-excel\/\",\"name\":\"How to format mobile phone numbers in Excel - SMS Marketing Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.firetext.co.uk\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.firetext.co.uk\/blog\/how-to-format-mobile-phone-numbers-in-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.firetext.co.uk\/blog\/how-to-format-mobile-phone-numbers-in-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.firetext.co.uk\/blog\/wp-content\/uploads\/2022\/04\/how-to-format-numbers-in-excel-featured-image.png\",\"datePublished\":\"2022-04-04T12:00:00+00:00\",\"dateModified\":\"2024-07-30T09:55:44+00:00\",\"description\":\"Excel at formatting your phone numbers in Excel. Follow our quick and easy three-step guide to get your numbers looking nice.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.firetext.co.uk\/blog\/how-to-format-mobile-phone-numbers-in-excel\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.firetext.co.uk\/blog\/how-to-format-mobile-phone-numbers-in-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/www.firetext.co.uk\/blog\/how-to-format-mobile-phone-numbers-in-excel\/#primaryimage\",\"url\":\"https:\/\/www.firetext.co.uk\/blog\/wp-content\/uploads\/2022\/04\/how-to-format-numbers-in-excel-featured-image.png\",\"contentUrl\":\"https:\/\/www.firetext.co.uk\/blog\/wp-content\/uploads\/2022\/04\/how-to-format-numbers-in-excel-featured-image.png\",\"width\":400,\"height\":320},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.firetext.co.uk\/blog\/how-to-format-mobile-phone-numbers-in-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.firetext.co.uk\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to format mobile phone numbers in Excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.firetext.co.uk\/blog\/#website\",\"url\":\"https:\/\/www.firetext.co.uk\/blog\/\",\"name\":\"SMS Marketing Blog\",\"description\":\"SMS Tips, Tricks and News from FireText\",\"publisher\":{\"@id\":\"https:\/\/www.firetext.co.uk\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.firetext.co.uk\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.firetext.co.uk\/blog\/#organization\",\"name\":\"FireText\",\"url\":\"https:\/\/www.firetext.co.uk\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/www.firetext.co.uk\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.firetext.co.uk\/blog\/wp-content\/uploads\/2021\/07\/Firetext-logo-white-1200-728.png\",\"contentUrl\":\"https:\/\/www.firetext.co.uk\/blog\/wp-content\/uploads\/2021\/07\/Firetext-logo-white-1200-728.png\",\"width\":1200,\"height\":728,\"caption\":\"FireText\"},\"image\":{\"@id\":\"https:\/\/www.firetext.co.uk\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/firetext.co.uk\/\",\"https:\/\/x.com\/firetext_uk\",\"https:\/\/www.instagram.com\/firetext_sms\/?hl=en-gb\",\"https:\/\/www.linkedin.com\/company\/firetext-communications-ltd\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.firetext.co.uk\/blog\/#\/schema\/person\/272c184e80b2a6fa926acaa2c42cb0dd\",\"name\":\"Megan Parker\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/www.firetext.co.uk\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/cd6b28787d033334d5547f45dadb5d7be3d95bd04e398fb430161f00ec346d5e?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/cd6b28787d033334d5547f45dadb5d7be3d95bd04e398fb430161f00ec346d5e?s=96&d=mm&r=g\",\"caption\":\"Megan Parker\"},\"url\":\"https:\/\/www.firetext.co.uk\/blog\/author\/m-parker\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to format mobile phone numbers in Excel - SMS Marketing Blog","description":"Excel at formatting your phone numbers in Excel. Follow our quick and easy three-step guide to get your numbers looking nice.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.firetext.co.uk\/blog\/how-to-format-mobile-phone-numbers-in-excel\/","og_locale":"en_GB","og_type":"article","og_title":"How to format mobile phone numbers in Excel - SMS Marketing Blog","og_description":"Excel at formatting your phone numbers in Excel. Follow our quick and easy three-step guide to get your numbers looking nice.","og_url":"https:\/\/www.firetext.co.uk\/blog\/how-to-format-mobile-phone-numbers-in-excel\/","og_site_name":"SMS Marketing Blog","article_publisher":"https:\/\/www.facebook.com\/firetext.co.uk\/","article_published_time":"2022-04-04T12:00:00+00:00","article_modified_time":"2024-07-30T09:55:44+00:00","og_image":[{"width":400,"height":320,"url":"https:\/\/www.firetext.co.uk\/blog\/wp-content\/uploads\/2022\/04\/how-to-format-numbers-in-excel-featured-image.png","type":"image\/png"}],"author":"Megan Parker","twitter_card":"summary_large_image","twitter_creator":"@firetext_uk","twitter_site":"@firetext_uk","twitter_misc":{"Written by":"Megan Parker","Estimated reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.firetext.co.uk\/blog\/how-to-format-mobile-phone-numbers-in-excel\/#article","isPartOf":{"@id":"https:\/\/www.firetext.co.uk\/blog\/how-to-format-mobile-phone-numbers-in-excel\/"},"author":{"name":"Megan Parker","@id":"https:\/\/www.firetext.co.uk\/blog\/#\/schema\/person\/272c184e80b2a6fa926acaa2c42cb0dd"},"headline":"How to format mobile phone numbers in Excel","datePublished":"2022-04-04T12:00:00+00:00","dateModified":"2024-07-30T09:55:44+00:00","mainEntityOfPage":{"@id":"https:\/\/www.firetext.co.uk\/blog\/how-to-format-mobile-phone-numbers-in-excel\/"},"wordCount":794,"publisher":{"@id":"https:\/\/www.firetext.co.uk\/blog\/#organization"},"image":{"@id":"https:\/\/www.firetext.co.uk\/blog\/how-to-format-mobile-phone-numbers-in-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/www.firetext.co.uk\/blog\/wp-content\/uploads\/2022\/04\/how-to-format-numbers-in-excel-featured-image.png","articleSection":["How To"],"inLanguage":"en-GB"},{"@type":"WebPage","@id":"https:\/\/www.firetext.co.uk\/blog\/how-to-format-mobile-phone-numbers-in-excel\/","url":"https:\/\/www.firetext.co.uk\/blog\/how-to-format-mobile-phone-numbers-in-excel\/","name":"How to format mobile phone numbers in Excel - SMS Marketing Blog","isPartOf":{"@id":"https:\/\/www.firetext.co.uk\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.firetext.co.uk\/blog\/how-to-format-mobile-phone-numbers-in-excel\/#primaryimage"},"image":{"@id":"https:\/\/www.firetext.co.uk\/blog\/how-to-format-mobile-phone-numbers-in-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/www.firetext.co.uk\/blog\/wp-content\/uploads\/2022\/04\/how-to-format-numbers-in-excel-featured-image.png","datePublished":"2022-04-04T12:00:00+00:00","dateModified":"2024-07-30T09:55:44+00:00","description":"Excel at formatting your phone numbers in Excel. Follow our quick and easy three-step guide to get your numbers looking nice.","breadcrumb":{"@id":"https:\/\/www.firetext.co.uk\/blog\/how-to-format-mobile-phone-numbers-in-excel\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.firetext.co.uk\/blog\/how-to-format-mobile-phone-numbers-in-excel\/"]}]},{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.firetext.co.uk\/blog\/how-to-format-mobile-phone-numbers-in-excel\/#primaryimage","url":"https:\/\/www.firetext.co.uk\/blog\/wp-content\/uploads\/2022\/04\/how-to-format-numbers-in-excel-featured-image.png","contentUrl":"https:\/\/www.firetext.co.uk\/blog\/wp-content\/uploads\/2022\/04\/how-to-format-numbers-in-excel-featured-image.png","width":400,"height":320},{"@type":"BreadcrumbList","@id":"https:\/\/www.firetext.co.uk\/blog\/how-to-format-mobile-phone-numbers-in-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.firetext.co.uk\/blog\/"},{"@type":"ListItem","position":2,"name":"How to format mobile phone numbers in Excel"}]},{"@type":"WebSite","@id":"https:\/\/www.firetext.co.uk\/blog\/#website","url":"https:\/\/www.firetext.co.uk\/blog\/","name":"SMS Marketing Blog","description":"SMS Tips, Tricks and News from FireText","publisher":{"@id":"https:\/\/www.firetext.co.uk\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.firetext.co.uk\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-GB"},{"@type":"Organization","@id":"https:\/\/www.firetext.co.uk\/blog\/#organization","name":"FireText","url":"https:\/\/www.firetext.co.uk\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.firetext.co.uk\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.firetext.co.uk\/blog\/wp-content\/uploads\/2021\/07\/Firetext-logo-white-1200-728.png","contentUrl":"https:\/\/www.firetext.co.uk\/blog\/wp-content\/uploads\/2021\/07\/Firetext-logo-white-1200-728.png","width":1200,"height":728,"caption":"FireText"},"image":{"@id":"https:\/\/www.firetext.co.uk\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/firetext.co.uk\/","https:\/\/x.com\/firetext_uk","https:\/\/www.instagram.com\/firetext_sms\/?hl=en-gb","https:\/\/www.linkedin.com\/company\/firetext-communications-ltd"]},{"@type":"Person","@id":"https:\/\/www.firetext.co.uk\/blog\/#\/schema\/person\/272c184e80b2a6fa926acaa2c42cb0dd","name":"Megan Parker","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.firetext.co.uk\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/cd6b28787d033334d5547f45dadb5d7be3d95bd04e398fb430161f00ec346d5e?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/cd6b28787d033334d5547f45dadb5d7be3d95bd04e398fb430161f00ec346d5e?s=96&d=mm&r=g","caption":"Megan Parker"},"url":"https:\/\/www.firetext.co.uk\/blog\/author\/m-parker\/"}]}},"_links":{"self":[{"href":"https:\/\/www.firetext.co.uk\/blog\/wp-json\/wp\/v2\/posts\/2518","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.firetext.co.uk\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.firetext.co.uk\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.firetext.co.uk\/blog\/wp-json\/wp\/v2\/users\/11"}],"replies":[{"embeddable":true,"href":"https:\/\/www.firetext.co.uk\/blog\/wp-json\/wp\/v2\/comments?post=2518"}],"version-history":[{"count":0,"href":"https:\/\/www.firetext.co.uk\/blog\/wp-json\/wp\/v2\/posts\/2518\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.firetext.co.uk\/blog\/wp-json\/wp\/v2\/media\/3890"}],"wp:attachment":[{"href":"https:\/\/www.firetext.co.uk\/blog\/wp-json\/wp\/v2\/media?parent=2518"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.firetext.co.uk\/blog\/wp-json\/wp\/v2\/categories?post=2518"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.firetext.co.uk\/blog\/wp-json\/wp\/v2\/tags?post=2518"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}