Dear All,
I attach herewith the data contains some data extracted from website. It is a mixture of 3 things,
a) Company Name
b) PAN NO
3) Amount
I tried to extract the amount by IFERROR(VALUE(RIGHT(A4,(LEN(A4)-FIND(" ",A4,47)))),""), but all the rows, the starting No say 47 is not accurate due to difference in name of company. Error is coming due to that. Further, When I applied ROUND to display like 12345.00 it has no effect. How this can be corrected ?
Regarding the PAN No, the character length is fixed = 10 digits i.e, after taking the amount from the data. The remaining portion become the Company Name.
Here, data - text to columns is not working nicely as character length is not fixed.
I want to avoid custom format several times as this data has to be changed frequently.
Help is requested.
VDS
I attach herewith the data contains some data extracted from website. It is a mixture of 3 things,
a) Company Name
b) PAN NO
3) Amount
I tried to extract the amount by IFERROR(VALUE(RIGHT(A4,(LEN(A4)-FIND(" ",A4,47)))),""), but all the rows, the starting No say 47 is not accurate due to difference in name of company. Error is coming due to that. Further, When I applied ROUND to display like 12345.00 it has no effect. How this can be corrected ?
Regarding the PAN No, the character length is fixed = 10 digits i.e, after taking the amount from the data. The remaining portion become the Company Name.
Here, data - text to columns is not working nicely as character length is not fixed.
I want to avoid custom format several times as this data has to be changed frequently.
Help is requested.
VDS