Separating elements of data in a cell

		Microsoft Office Forums > Microsoft Excel > Excel
Separating elements of data in a cell

03-17-2016, 10:17 PM

xor

Windows 10 Separating elements of data in a cell

Office 2016

Expert

Join Date: Oct 2015

Posts: 1,101

Try this formula:

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

Tags

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Move the data at bottom cell to right side of the cell	kcyag91	Excel	1	01-28-2016 12:28 AM
Data validation,force cell to be filed with number if respective cell is not empty	nicholes	Excel Programming	0	08-01-2015 09:08 AM
Separating Name, Birthday, email, address, etc that is in one cell	ABreyen	Excel	1	07-01-2015 05:11 AM
Copying data from one cell to another where condition is third cell	fairyca	Excel	4	03-30-2014 08:22 AM
How to populate cells in Sheet2 with Data Source query using cell data from Sheet1	bobznkazoo	Excel	2	03-27-2014 11:14 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:03 PM.