Thread
:
how to separate number in excel
View Single Post
11-21-2017, 09:46 AM
NBVC
Windows 10
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
NBVC
View Public Profile
Find all posts by NBVC