TEXT TO COLUMN FUNCTION
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. |
TEXT TO COLUMN FUNCTION
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. |
All times are GMT +1. The time now is 01:23 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com