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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

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