Results 1 to 3 of 3

Thread: How can I split a text to different columns in Microsoft Excel

  1. #1
    Join Date
    Oct 2011
    Posts
    89

    How can I split a text to different columns in Microsoft Excel

    My data in col A is as follows:
    • 1*15
    • 101268*6
    • 101352*16
    • 101513*11
    • 10406*2
    • 10406*37
    • 10411*13
    • 10411*7

    I want to add two columns with the data preceding the * going into Col B and the data following the * going into Col C. I can't use RIGHT or LEFT because the data is not the same length. If someone knows a way to do this, I'd certainly appreciate knowing how. Thanks in advance.

  2. #2
    Join Date
    Aug 2011
    Posts
    580

    Re: How can I split a text to different columns in Microsoft Excel

    There is a simple way that you can try out. First have a look at Data, text to columns, post back if you need help with it. You can try searching for more help by pressing F1., There are ample of details provided in the same. Try to search with the exact given keywords.

  3. #3
    Join Date
    Aug 2011
    Posts
    540

    Re: How can I split a text to different columns in Microsoft Excel

    I am not sure that there is any kind of precise schedule or command available that can help you to this. Try this DATA - TEXT COLUMNS. First insert blank columns to the right of where you have data in your case precise 3 empty columns, then select the column that has the data and go to Data - Text to Columns and you follow the wizard asks you which character are separated fields, usually the BLANK, but may be coma, etc.

Similar Threads

  1. Find the number of text repeated in columns of Excel
    By Jigisha in forum MS Office Support
    Replies: 4
    Last Post: 24-02-2012, 04:35 PM
  2. How split a sentence into Word in Microsoft Excel
    By Tur^turro in forum MS Office Support
    Replies: 4
    Last Post: 15-02-2012, 05:57 PM
  3. My Text are overlapping with other columns in Excel
    By RajiI in forum MS Office Support
    Replies: 4
    Last Post: 27-01-2012, 07:20 PM
  4. How to Split a Single Cell in Microsoft Excel 2007
    By Corey Dunnett in forum Windows Software
    Replies: 2
    Last Post: 11-01-2012, 12:48 PM
  5. How to compare text string of two different columns in Excel
    By Chini mao in forum Windows Software
    Replies: 3
    Last Post: 06-01-2012, 04:50 PM

Tags for this Thread

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
  •  
Page generated in 1,642,717,373.26073 seconds with 17 queries