Prerequisite
Know how to use "DATE", "RIGHT" and "LEFT" formulas individually.
Please refer to Microsoft help for Syntax.
To create date we need year, month and day.
1. Type =LEFT(F2,4). Drag or copy paste the formula all the way (to cover the all the IDs). This will be the year.
2. Type =RIGHT(LEFT(F2,6),2) Drag or copy paste the formula all the way (to cover the all the IDs). This will be the month.
3. Type =RIGHT(LEFT(F2,8),2) Drag or copy paste the formula all the way (to cover the all the IDs). This will be the day.
4. Type =DATE(E2,D2,C2) Drag or copy paste the formula all the way (to cover the all the IDs). This will be the date.
All comments are welcome.
Please refer to Microsoft help for Syntax.
Possible Usage
In the earlier post we talked about how to create unique IDs using data code or time stamp. Here we will see how to do the reverse. This kind of situation does arises in Operation or Manufacturing environments.
The steps (How to do)
To create date we need year, month and day.
1. Type =LEFT(F2,4). Drag or copy paste the formula all the way (to cover the all the IDs). This will be the year.
2. Type =RIGHT(LEFT(F2,6),2) Drag or copy paste the formula all the way (to cover the all the IDs). This will be the month.
3. Type =RIGHT(LEFT(F2,8),2) Drag or copy paste the formula all the way (to cover the all the IDs). This will be the day.
4. Type =DATE(E2,D2,C2) Drag or copy paste the formula all the way (to cover the all the IDs). This will be the date.
DONE.
All comments are welcome.
ExpiresDefault access plus 1 year
The excel left and right function facilitate me the work. I often use it and I often came back to the following site, which has given me so often bailed out. This website I’ ll like to share with you: http://www.excel-aid.com/the-excel-left-and-right-functions-2.html
ReplyDelete