Hi

Use the LEFT, RIGHT and MID functions to perform the split.


--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"ellen" wrote:

IS THERE A WAY TO SEPARATE THE DATA BY SAYING THAT THE LAST TWO (OR LAST X
DIGITS) DIGITS IS THE DELIMITER? MAY06 BECOMES MAY 06.