Microsoft Office Forums - View Single Post - Search for specific data in a text string

Thread: Search for specific data in a text string

View Single Post

Old

05-20-2017, 11:51 AM

xor

xor is offline

xor uses Windows 10

Windows 10 xor uses Office 2016

xor uses Office 2016

Office 2016

Expert

Join Date: Oct 2015

Posts: 1,097

xor is a name known to all

xor is a name known to all

xor is a name known to all

xor is a name known to all

xor is a name known to all

xor is a name known to all

Default

With your text in A1 try:

--MID(A1,FIND("AGE",A1)+5,FIND(" ",A1,FIND("AGE",A1)+5)-(FIND("AGE",A1)+5))

Reply With Quote