Separate string into separate cells

Katasa

New member
Joined
Jan 23, 2014
Messages
2
Reaction score
0
Points
0
Good day to all,
I worked with an archeic system called Blue Vista and need help. When doing a query the system will produce was you see below but every row is in cell a1 a2 a3. i would like to separate a1 into b1 c1 d1 e1 f1 etc etc....
Anyone have any ideas?:eek:hwell:

290 290 290 290 290 290 290 290 295 295 288 288 338 338
290 283 290 285 290 284 290 285 295 288 288 283 338 331
290 189 290 227 290 238 295 211 288 172 338 244
 

NBVC

Super Moderator
Staff member
Joined
May 20, 2011
Messages
1,518
Reaction score
0
Points
0
Location
Mississauga, Canada
Excel Version(s)
Excel 2016
Select the column. Go to Data|Text to Columns, select Delimited, then Next. Then select Space and click Finish.
 
Top