Hi,
I have a data sheet with data in different cells, as below
A1 - Approver: Approve Date: Approval Comments:
B1 - Approver: Approve Date: Approval Comments:
I have used =Right, =MID and =Left to extract this information, but this is long and it wont work in other cells as the data is different, can i use any other function to search the whole sheet and output the results that i want.
Is there an easy way to extract this data.
BR
I have a data sheet with data in different cells, as below
A1 - Approver: Approve Date: Approval Comments:
B1 - Approver: Approve Date: Approval Comments:
I have used =Right, =MID and =Left to extract this information, but this is long and it wont work in other cells as the data is different, can i use any other function to search the whole sheet and output the results that i want.
Is there an easy way to extract this data.
BR