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.
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)
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.
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.
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.