Excel - Extract the Right Two Letters in Excel - Episode 1158

1,266 views · Published 15 December 2009 · 2:04 · Indexed 31 October 2026

Channel: MrExcel.com · 2009 · Education

Watch on YouTube

Microsoft Excel Tutorial: Easy Solution for Extracting Right-Most Characters in Excel | Text to Columns.

Welcome back to the MrExcel netcast, where we provide you with helpful tips and tricks to make your Excel experience even better. In today's episode, we will be discussing a question sent in by David regarding the Text to Columns feature in Excel. David's question is a great one and it has to do with going right-to-left in the Fixed Width option. This is a common issue that many Excel users face, and we are here to provide you with a solution.

David's specific problem is that he needs to grab the two rightmost characters from a set of data, but the length of the data is unknown. Unfortunately, in the Fixed Width option, there is no way to specify that we want to start from the right edge of the data. This means that we are left with a relatively painful solution of using the RIGHT and LEFT functions to extract the desired characters. However, with the help of Easy-XL, this process can be made much simpler and more efficient.

Easy-XL offers a solution to this problem with their Split Columns feature. By selecting the ID column and choosing to split it from the right-hand side, we can specify the number of characters we want to extract, in this case, three. Easy-XL also allows us to create a remainder column, which will contain the remaining characters from the original data. This is a much more efficient and user-friendly way to extract data from the right side of a column in Excel.

So, if you're tired of using complicated formulas and functions to extract data from the right side of a column, give Easy-XL a try. With just a few clicks, you can split your data and have the desired characters in a separate column. Don't waste any more time struggling with Excel, visit www.easy-xl.com to learn more about this amazing tool and make your Excel experience even better. Thank you for watching this netcast from MrExcel, and we'll see you next time with more helpful tips and tricks.

Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/

You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/


Table of Contents:
(00:00) Get the 2 right-most characters from a cell in Excel
(00:20) Difficulty with Fixed Width Text to Columns 
(00:41) Solution using Formulas 
(01:08) Converting Formulas to Values 
(01:18) Limitations and Future Possibilities 
(01:46) Clicking Like really helps the algorithm

#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial


This video answers these common search terms:
Convert formulas to values
Fixed Width
Grab rightmost characters
Microsoft Excel
Part numbers
Paste Values
Remainder Column
Right-to-left
Split Columns
Text to Columns


Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1152773/


David asks how to use Text to Columns to grab the right-most two characters from a column. Episode 1158 shows you how.

More from this channel