Results 1 to 5 of 5

Split a column into multiple columns

Threaded View

  1. #1
    Registered User
    Join Date
    11-08-2015
    Location
    New jersey
    MS-Off Ver
    2013
    Posts
    8

    Split a column into multiple columns

    I have a column with protease sequece. It is a big text string. For example

    if GTAGAGCTGT is in one column, Starting from every letter, 5 letter should be created and it should be split like below and separate columns should be created


    Column1 Column2 Column3 Column4 Column5 Column6
    GTAGA TAGAG AGAGC GAGCT AGCTG GCTGT


    Please help. I am attaching the excel file and I have highlighted the text column in yellow. The new columns should be created on the right side of the existing data.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Split uneven data from a single columns to multiple columns
    By pfoz in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 05-13-2013, 08:24 AM
  2. How to split Time by days from one column to multiple columns?
    By SureshNaiduA in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-13-2013, 01:45 PM
  3. [SOLVED] Split column into multiple columns at predetermined rows
    By nukeemaway in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-30-2012, 09:32 AM
  4. [SOLVED] Need macro to split one column into multiple columns based on _ and spacing
    By snely in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 09-17-2012, 10:05 AM
  5. [SOLVED] Arbitrary points: Split single column into multiple columns
    By ChasingShadows in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-23-2012, 11:08 PM
  6. Split data in a column into multiple columns in excel vba
    By bujji1305 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-21-2012, 09:10 AM
  7. Split column of names into multiple columns
    By madaboutgolf in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-16-2011, 04:59 PM
  8. Split one column of Info into multiple columns in the next sheet
    By hthomas615 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-17-2011, 08:40 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1