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, 12:02 PM

NoSparks

Windows 7 64bit Formula to extract last two letters from each word

Office 2010 64bit

Excel Hobbyist

Join Date: Nov 2013

Location: British Columbia, Canada

Posts: 842

@ xor
I'm no good with formulas, but I think you need to re-visit populating C1 to V1 as it misses the second year shown in A1

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:58 PM.