how to separate number in excel

yoyo4 · #1 11-21-2017, 08:40 AM

hi all,

As a example ,
following numbers in cell .(with and without space)
4000 140000 181000 205 1800
27000180400 3061900

need to separate 5 column.

NBVC · #2 11-21-2017, 09:46 AM

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

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