Go Back   TechArena Community > Software > Windows Software
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



Parsing data in Excel Sheet

Windows Software


Reply
 
Thread Tools Search this Thread
  #1  
Old 04-02-2011
Member
 
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.

Reply With Quote
  #2  
Old 04-02-2011
Member
 
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)
Reply With Quote
  #3  
Old 04-02-2011
Member
 
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.
Reply With Quote
  #4  
Old 04-02-2011
Member
 
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.
Reply With Quote
  #5  
Old 04-02-2011
Member
 
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.
Reply With Quote
Reply

  TechArena Community > Software > Windows Software
Tags: , , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Parsing data in Excel Sheet"
Thread Thread Starter Forum Replies Last Post
excel spread sheet data transfer help elijah58 Software Development 2 29-08-2012 04:24 PM
Want to copy Excel Chart to another sheet without the Data LuniA MS Office Support 5 25-02-2012 11:09 AM
Is there a way to populate one sheet data from another in Excel M.N.S MS Office Support 2 23-02-2012 05:55 PM
How to add data in Excel when sheet protection is activated Lanka Boy Microsoft Project 2 08-01-2012 09:14 PM
How to insert HyperTerminal data into excel sheet. Shaina Na Microsoft Project 1 08-01-2012 07:44 PM


All times are GMT +5.5. The time now is 01:52 AM.