{"id":4179,"date":"2016-08-22T23:33:58","date_gmt":"2016-08-22T21:33:58","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=4179"},"modified":"2023-11-30T21:20:30","modified_gmt":"2023-11-30T20:20:30","slug":"extracting-data-with-excels-right-formula","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/extracting-data-with-excels-right-formula\/","title":{"rendered":"Extracting Data with Excel’s RIGHT Formula"},"content":{"rendered":"

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

It returns the last\u00a0character or characters in a text string, based on the number of characters you specify.<\/p>\n

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

=RIGHT(text<\/span>,<\/span>\u00a0[num_chars]<\/span>)<\/p>\n

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

=RIGHT(look in this cell<\/span>,<\/span>\u00a0extract X characters<\/span>)<\/p>\n

\n

There are times when you will need to extract the last\u00a0few characters of text within a cell, e.g. From a serial number, part number, name, address\u00a0etc.<\/p>\n

The RIGHT\u00a0<\/b>formula in Excel can help you parse and extract the needed text easily.<\/p>\n

In our example below, we have an address which has a zip code at the end (the zip code is fixed at 5 characters long)\u00a0and we want to extract all\u00a0of the zip codes in our address list.<\/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