VBABEGINER
Well-known Member
- Joined
- Jun 15, 2011
- Messages
- 1,232
Hi All,
I need a vba code, where I can split range value in code and date.
This are the values in Col A.
Here, "05/89" these are dates. I want, "CGU 002" these in A range and "05/89" these in B Col with addition of "05/01/89"..
Can some one pls help..
I need a vba code, where I can split range value in code and date.
This are the values in Col A.
CGU 002 - 05/89 ECG 21 501 - 05/00 ECG 21 762 - 04/14 CG 21 73 - 01/00 CG 21 06 - 05/14 CG 21 35 - 10/01 CG 21 47 - 12/07 CG 21 54 - 01/96 CG 21 55 - 09/99 CG 21 86 - 12/04 CG 21 96 - 03/05 CG 22 34 - 04/13 CG 22 43 - 04/13
CGU 002 - 05/89 ECG 21 501 - 05/00
<colgroup><col></colgroup><tbody>
</tbody>
<colgroup><col></colgroup><tbody>
</tbody>
Here, "05/89" these are dates. I want, "CGU 002" these in A range and "05/89" these in B Col with addition of "05/01/89"..
Can some one pls help..