Split Columns Question

Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Split Columns Question

  1. #1
    New Member
    Join Date
    Dec 2013
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Split Columns Question

     
    Greetings - I am testing the Excel addin and after merging two sheets I ended up with two columns combined. I guess I don't quite have the merge options figured out. I would like to now split one of the columns which contains a company name and the sales rep name, for example "Mr Excel Tickling Keys Tracy Syrstad" where there is only spaces. Most of the sales reps names are only two words and are on the left side of the column but I don't see an option that would allow me to split the column after the second or anything that would work. Any ideas on how to accomplish this without creating the sheet again?

    Thanks.

  2. #2
    Board Regular Easy-XL Support's Avatar
    Join Date
    Nov 2009
    Location
    Ottawa, Canada
    Posts
    140
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Split Columns Question

      
    The Easy-XL -> Columns -> Split Columns command will allow you to split a column up into multiple words based on a separator character that you specify. It sounds like you may have already done this using a space as the separator character. This would have resulted in a bunch of new columns being added to the sheet, each one containing a single word. You could then use the Easy-XL -> Columns -> Combine Columns command to recombine the first two of these columns (remember to add a space between each column you combine).

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com