Microsoft Office Forums - View Single Post - Substring to return numbers

Thread: Substring to return numbers

View Single Post

Old

07-22-2016, 10:03 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,100

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

Then maybe:

=MID(N4,FIND(A1,N4)+LEN(A1)+1,FIND(A2,N4)-LEN(A2)-2)

where A1 = bRef and A2 = cRef.

Reply With Quote