Microsoft Office Forums - View Single Post - [Solved] Separating elements of data in a cell

Thread: [Solved] Separating elements of data in a cell

View Single Post

Old

03-17-2016, 10:17 PM

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

Try this formula:

=--MID(A1,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A1&"012345 6789")),2)

Reply With Quote