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
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
-
2:13
Excel Calculate Decimal Hours from two Time Cells - Episode 902
-
3:57
Excel 2007 - Color of Selected Sheets is too much like unselected sheets - Episode 907
-
2:48
Excel - Adding Equals Icon to Excel QAT - Build Formula with Mouse - Episode 911
-
3:30
Excel Grouping Percentages into Buckets for a Pivot Table - Method 2 - Episode 913
-
2:04
Excel Change Color of Selected Cells - Episode 914
-
4:38
Excel - Auto Numbering a List with Frequent Inserts & Deletes - Episode 916
-
2:00
Excel Hiding Data in Plain Site - Episode 919
-
2:20
Excel - Bring Back The Full Excel 2003 Dialogs In Excel! - Episode 920