Thread: [Solved] Formula to extract last two letters from each word
View Single Post
 
Old 04-05-2019, 11:47 PM
xor xor is offline Windows 10 Office 2016
Expert
  
Join Date: Oct 2015
Posts: 1,100
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default Formula to extract last two letters from each word
See cell B1 in the attached.
As you can see the solution requires helper cells (as C1:V1). If you so wish these can be moved to somewhere out of sight.

Edit:
Only now I see that you use Office 2010 so I guess you can't use above solution as it requires the function TEXTJOIN which is only available in the most recent version of Excel.
Attached Files
File Type: xlsx Extract_Last_Two.xlsx (9.7 KB, 12 views)
Reply With Quote