View Single Post
 
Old 11-21-2017, 09:46 AM
NBVC's Avatar
NBVC NBVC is offline Windows 10 Office 2013
The Formula Guy
 
Join Date: Mar 2012
Location: Mississauga, CANADA
Posts: 215
NBVC will become famous soon enoughNBVC will become famous soon enough
Default

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
Reply With Quote