{"id":5776,"date":"2017-02-13T17:50:17","date_gmt":"2017-02-13T16:50:17","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=5776"},"modified":"2023-11-30T20:59:33","modified_gmt":"2023-11-30T19:59:33","slug":"clear-everything-hyphen-excels-replace-formula","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/clear-everything-hyphen-excels-replace-formula\/","title":{"rendered":"Clear Everything Before the Hyphen with Excel’s REPLACE Formula"},"content":{"rendered":"

What does it do?<\/strong><\/em><\/p>\n

Replaces part of a text string, based on the number of characters you specify, with a different text string<\/p>\n

Formula breakdown:<\/strong><\/em><\/p>\n

=REPLACE(old_text, start_num, num_chars, new_text<\/span><\/span><\/span><\/span>)<\/p>\n

What it means:<\/strong><\/em><\/p>\n

=REPLACE(this cell<\/span>, starting from this number, all the way to this number, with this new text<\/span><\/span><\/span><\/span>)<\/p>\n

\n

Once I was given a list of phone numbers in their international format. \u00a0But for my needs, I did not want to include the country code and I just wanted the phone number.<\/p>\n

I was looking for a quick way to remove the country code.<\/p>\n

I discovered a cool way to do this using the\u00a0REPLACE\u00a0<\/strong>formula! Goodbye to manual adjustments!<\/p>\n

I explain how you can do this and please\u00a0go to the bottom of the page to see the animated gif tutorial:<\/p>\n

\n