@Dear All,
While downloading data from Tally, I received a statement of accounts as per attachment. Here, The cheue no and amount is to be extracted in a separate column. I used Left and Right function to take the cheque no alone. But this is a lengthy process. How to simply this ? The suggested format is highlighted in Turquoise Colour. Even the amount is to be taken separately. This is a voluminous data and makes time consuming.
How to to do this. Your help is requested.
VDS
While downloading data from Tally, I received a statement of accounts as per attachment. Here, The cheue no and amount is to be extracted in a separate column. I used Left and Right function to take the cheque no alone. But this is a lengthy process. How to simply this ? The suggested format is highlighted in Turquoise Colour. Even the amount is to be taken separately. This is a voluminous data and makes time consuming.
How to to do this. Your help is requested.
VDS