| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF Function for column containing text - Excel 2007 | New Users to Excel | |||
| Text to Column Function Rejects Zeros | New Users to Excel | |||
| Function to move text 65 characters to next row in column? | Excel Worksheet Functions | |||
| Looking for a Function which counts the repeatition of text in a column | Excel Worksheet Functions | |||
| Wrap text in column headers to fit text in column | Excel Discussion (Misc queries) | |||
Linear Mode
