Results 1 to 5 of 5

Thread: Parsing data in Excel Sheet

  1. #1
    Join Date
    Sep 2010
    Posts
    57

    Parsing data in Excel Sheet

    The use of the Excel Sheet is common among the peoples who are making the use of the various files in it. I have been using one cell that is having the list of the data that are being separated in it. And also I have tried out the text to column option but still it was of no use. I am unable to get the issue solved of the column and the data that is being parsed in it. I have around 13,000 lines that needed to be parsed out but I am not being able to do it. And help in here would be very useful for me.

  2. #2
    Join Date
    Jun 2009
    Posts
    1,518

    Re: Parsing data in Excel Sheet

    If you are having the value suppose 3.454 in A3 for example and take the 9 values that you are going to use for the B3 column in the excel sheet. Also you don’t have to see the various values of columns that is present in B and then check out the 9 values that are way to different for each other. And you can just make the use of the formula that is being given below:
    For example for the column of C3:
    =MID(B3,1,9)

    And also in D3:

    =MID($B3,FIND(C3,$B3)+10,9)

  3. #3
    Join Date
    Nov 2008
    Posts
    1,514

    Re: Parsing data in Excel Sheet

    And if the above solution is not working for the files that you are using in the excel sheet, then you can just follow the example that is just given below for the columns that you are using in the excelsheet:
    This you can just make use for the column of C3:
    =SUBSTITUTE(B3,CHAR(10),"#")
    After that you have to copy paste C3 and then make the use of the special paste in it along with the values and then you have to check out the text to columns that is having the file of the # in it.

  4. #4
    Join Date
    Mar 2009
    Posts
    1,360

    Re: Parsing data in Excel Sheet

    And then you have another options that are given below:
    You can just make the use of C4:K4 be the values that you can select X2:X9, and then you have to type:

    =TRANSPOSE(, then select C4:K, then after that type)

    , and then press the key of : CTRL+Shift+Enter
    This will help you to create the array formula in it. And the working depends that what kind of the values are being used by you and then you can just check out the listing of the various files that is having the value related to the various columns used in the file of the excel and the parsing can be done on it.

  5. #5
    Join Date
    Nov 2008
    Posts
    1,259

    Re: Parsing data in Excel Sheet

    Check out the various details of the columns that are being defined below:
    Check out for the column of C3:

    =MID(B2,2,8)

    And then in the column of D2:

    =MID($B2,FIND($B2,$B2)+11,8)


    And then in the E5 column you have to get the below given formula:

    =MID($B2,FIND($B2,$B2)+19,8)

    After that you can just get the formula similar to the column of F2:

    =MID($B2,FIND($B2,$B2)+20,8)
    And when you are getting the above formulas then issue of the spacing will also be removed from it. And see that when the transposing of the various files are being done do it properly in it.

Similar Threads

  1. excel spread sheet data transfer help
    By elijah58 in forum Software Development
    Replies: 2
    Last Post: 29-08-2012, 04:24 PM
  2. Replies: 5
    Last Post: 25-02-2012, 11:09 AM
  3. Replies: 2
    Last Post: 23-02-2012, 05:55 PM
  4. How to add data in Excel when sheet protection is activated
    By Lanka Boy in forum Microsoft Project
    Replies: 2
    Last Post: 08-01-2012, 09:14 PM
  5. How to insert HyperTerminal data into excel sheet.
    By Shaina Na in forum Microsoft Project
    Replies: 1
    Last Post: 08-01-2012, 07:44 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,938,378.16735 seconds with 17 queries