Remove everything after the last instance of a digit/letter combo

xor · #2 05-12-2019, 09:37 PM

I guess there is a much better way to do this but until further you might want to try (with your string in A3)

=MID(A3,1,FIND(" ",A3,MIN(IF(ISNUMBER(FIND({1,2,3,4,5,6,7,8,9,0},A3 )),FIND({1,2,3,4,5,6,7,8,9,0},A3)))))&" "&MID(A3,FIND(" ",A3,MIN(IF(ISNUMBER(FIND({1,2,3,4,5,6,7,8,9,0},A3 )),FIND({1,2,3,4,5,6,7,8,9,0},A3))))+1,FIND(" ",A3,FIND(" ",A3,MIN(IF(ISNUMBER(FIND({1,2,3,4,5,6,7,8,9,0},A3 )),FIND({1,2,3,4,5,6,7,8,9,0},A3))))+1)-FIND(" ",A3,MIN(IF(ISNUMBER(FIND({1,2,3,4,5,6,7,8,9,0},A3 )),FIND({1,2,3,4,5,6,7,8,9,0},A3)))))

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Letter Template /w combo box list	etruz	Word	4	10-31-2018 05:16 AM
Pasting a table with combo boxes to a new document looses the combo box	bobsut@enviro-consult.com	Word	1	01-03-2017 01:29 PM
Regex/wildcard search for dates with 2-digit and 4-digit years	Marrick13	Word VBA	2	01-29-2016 07:04 AM
A challenging digit by digit manipulation, rotate the digit in range of 0 to 9	laucn	Excel Programming	14	05-17-2015 12:12 PM
Macro to keep first instance and remove duplicates in certain column	zhead	Excel	2	03-18-2015 10:16 AM