TEXT TO COLUMN FUNCTION

[ellen]

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.

 

[Wigi]

Hi

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