0
Undo
Votes
I would like to see if anyone would be able to help me get an Excel formula:
I need to Extract the first 6 characters from a specific row and the last 6 characters also from that row but will need to skip blank cells.
For Example: Based on the attached screenshot. I need a Start Date (AG2) and End Date AG2 from the following range AI2:AN2 which would give me Start Date of 08-Jun and End Date of 19-Jul.
I need to Extract the first 6 characters from a specific row and the last 6 characters also from that row but will need to skip blank cells.
For Example: Based on the attached screenshot. I need a Start Date (AG2) and End Date AG2 from the following range AI2:AN2 which would give me Start Date of 08-Jun and End Date of 19-Jul.
- Page :
- 1
There are no replies made for this post yet.