Formula to extract last two letters from each word

Pecoflyer · #1 04-06-2019, 08:25 AM

Quote:

It did get me thinking in another direction through. Maybe if I extract each year into its own cell, trim the first two numbers off each and put these new values back together. Might it be better to modify the formula in my original post to extract the last 2 numbers and string out the capacity to do up to 20 words.

Yes, but it would be very cumbersome, even using Text to columns .
And to put the results together you would have something like =A1&" "&A2&" "....
The UDF NoS provided would be easier ( haven't tested it but I suppose he/she did

)

xor · #2 04-06-2019, 09:52 AM

I think NoSparks solution is unbeatable

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

14spar15 · #3 04-06-2019, 10:37 AM

Worked like a charm. Already using xlsm so this fit right in and this is so simple. Maybe "simple" is the wrong word because I can't figure out how it works. Very short and compact. It's something else I can study when I get caught up here. Many Thanks..

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