srizki
Well-known Member
- Joined
- Jan 14, 2003
- Messages
- 1,844
- Office Version
- 365
- Platform
- Windows
Hi all,
I have the following, (a partial list).
<colgroup><col></colgroup><tbody>
</tbody>I need to first 6 digits as for example, Dec-16, Jun-18 etc.
I can not use =LEFT(F4,6)
There must be an addition to this above formula.
Thanks,
I have the following, (a partial list).
1220160070029210 |
0620180070029213 |
0120170070029213 |
1120160070029210 |
0420170070029213 |
<colgroup><col></colgroup><tbody>
</tbody>
I can not use =LEFT(F4,6)
There must be an addition to this above formula.
Thanks,