Results 1 to 3 of 3

Thread: Separate string into separate cells

  1. #1

    Separate string into separate cells



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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?

    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

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,489
    Articles
    0
    Excel Version
    Excel 2016
    Select the column. Go to Data|Text to Columns, select Delimited, then Next. Then select Space and click Finish.


  3. #3
    Quote Originally Posted by NBVC View Post
    Select the column. Go to Data|Text to Columns, select Delimited, then Next. Then select Space and click Finish.
    whooooo hooooooo Thank you

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •