So I use have this dataset:
<tbody>
</tbody>
So I have to divide this data into three columns: Name, Share and Value
I used the following functions to get the data:
<tbody>
</tbody>
To get these data:
<tbody>
</tbody>
But as far as I have googled there is not an option in VBA to use the LEFT or RIGHT function to read data eg.: after the first '..' happens from the right side.
Is there any way it could be done?
If you have questions let me know I will elaborate.
Name with Share & Value | |
<tbody> </tbody> | |
<tbody> </tbody> | |
<tbody> </tbody> | |
<tbody> </tbody> | |
<tbody> </tbody> | |
<tbody> </tbody> | |
<tbody> </tbody> | |
<tbody> </tbody> | |
<tbody> </tbody> |
<tbody>
</tbody>
So I have to divide this data into three columns: Name, Share and Value
I used the following functions to get the data:
Name | Share & Value | Share | Value |
=TRIM(LEFT(SUBSTITUTE(A2,"..",REPT(" ",99)),99)) | =TRIM(RIGHT(SUBSTITUTE(A2,".",REPT(" ",99)),99)) | =TRIM(LEFT(SUBSTITUTE(B2," ",REPT(" ",99)),99)) | =TRIM(RIGHT(SUBSTITUTE(A2," ",REPT(" ",99)),99)) |
<tbody>
</tbody>
To get these data:
Name | Share & Value | Share | Value | ||||
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody>
</tbody>
But as far as I have googled there is not an option in VBA to use the LEFT or RIGHT function to read data eg.: after the first '..' happens from the right side.
Is there any way it could be done?
If you have questions let me know I will elaborate.