Formula to extract last two letters from each word

14spar15 · #1 04-05-2019, 12:00 PM

Hello, I have a cell that has a list of years (example 1999 2000 2001 2002 2003 2004) and I need a formula to change this example into (99 00 01 02 03 04). There may be anywhere from one year up to 20 years in this cell. I found this

Code:

=LEFT(A1,1)&MID(A1,FIND(" ",A1&" ",1)+1,1)&MID(A1&"  ",FIND(" ",A1&"  ",FIND(" ",A1&" ",1)+1)+1,1)

that I was going to modify (It uses first letter of each word) but I am finding out it is only going to work for up to 3 years. I guess I could draw it out to 20 words/numbers but it seems there is probably a better way. Any ideals here? Thank-You

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