I have a data set in below type in a column. How can I extract & put them into separate columns.
<tbody>
</tbody>
I worked to some extent using below formula.
MID(A1,1,FIND("+",A1)-1) = Code:1 , MID(Q7,FIND("+",A1,1)+1,FIND("+",A1,2)) = Name:Bo
I want to get the data into separate cells as follows;
<tbody>
</tbody>
<tbody> </tbody><colgroup><col></colgroup> | ||||||
<tbody> </tbody><colgroup><col></colgroup> | ||||||
<tbody> </tbody><colgroup><col></colgroup> |
<tbody>
</tbody>
I worked to some extent using below formula.
MID(A1,1,FIND("+",A1)-1) = Code:1 , MID(Q7,FIND("+",A1,1)+1,FIND("+",A1,2)) = Name:Bo
I want to get the data into separate cells as follows;
Code:1<strike></strike> | Name:Book<strike></strike> | Size:200pg<strike></strike> | Price:100<strike></strike> | Vendor:Abooks<strike></strike> |
Code:2<strike></strike> | Name:Pen<strike></strike> | Size:Standard<strike></strike> | Price:10<strike></strike> | Vendor:Abooks<strike></strike> |
Code:3<strike></strike> | Name:Bag<strike></strike> | Size:Standard<strike></strike> | Price:250<strike></strike> | Vendor:TopBags<strike></strike> |
<tbody>
</tbody>