Results 1 to 2 of 2

Thread: Extract the contents of one column into multiple columns

  1. #1

    Extract the contents of one column into multiple columns



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

    Hi I want to see the contents of a column in three separate column
    Thanks
    Link My File :
    Click image for larger version. 

Name:	xls.jpg 
Views:	19 
Size:	109.3 KB 
ID:	2640
    Attached Files Attached Files

  2. #2
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,480
    Articles
    0
    Excel Version
    365
    First select the cells, then using Data|Text to Columns, choose the Fixed width option in Step 1, click Next, remove all but the break lines at positions 51 and 84, click Finish. Now you can move the columns into the order you want.

Posting Permissions

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