how to separate number in excel

		Microsoft Office Forums > Microsoft Excel > Excel
how to separate number in excel

FAQ

Thread Tools

Display Modes

11-21-2017, 09:46 AM

NBVC

Windows 10 how to separate number in excel

Office 2013

The Formula Guy

Join Date: Mar 2012

Location: Mississauga, CANADA

Posts: 215

Try:

=0+TRIM(MID(SUBSTITUTE($A1," ",REPT(" ",100)),1+(100*(COLUMNS($A1:A1)-1)),100))

where A1 contains first cell of space separated numbers.

drag formula across 5 columns and down

Tags

excel 2013, excel formula

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Trying to associate .XLSX,.XLS,.CSV files to open in Excel 2013 in separate process	WinSock64	Excel	0	02-06-2015 01:30 AM
How do I separate an address into separate cells	Austcart	Excel	2	01-18-2015 03:48 PM
Separate lines in an Excel cell - possible? If so, how?	mtcn	Excel	5	12-12-2014 01:06 PM
Can I use the filter function to separate letters into separate files?	drhauser	Mail Merge	2	12-14-2011 02:18 PM
Any easy way to separate a Word document into separate files?	SamHelm	Word	0	08-21-2010 05:29 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:49 PM.