Formula to extract last two letters from each word

		Microsoft Office Forums > Microsoft Excel > Excel
Formula to extract last two letters from each word

04-06-2019, 09:52 AM

xor

Windows 10 Formula to extract last two letters from each word

Office 2016

Expert

Join Date: Oct 2015

Posts: 1,101

Formula to extract last two letters from each word

I think NoSparks solution is unbeatable

If however you prefer no VBA you might be interested in the attached.

Attached Files

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Formula to Extract text from a text string	Haha88	Excel	2	11-14-2017 01:32 AM
How to assign numbers to letters and then create a formula to add them together for a rota	Mskapri	Excel	6	04-01-2017 03:05 PM
I'm looking for a formula to extract all the text before the last name in a cell	Gef	Excel	4	02-01-2015 07:14 PM
Word not 'rounding' letters up to word in next line (parents and orphans)	Asa	Word	4	09-13-2014 06:47 PM
extract text with formula	s7y	Excel	7	06-05-2013 06:18 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:57 PM.