Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Convert string to date & select rows with certain feature
Hi guys, just can't figure this out:
1. Suppose I have 100 rows of data, rows are such as: "ABMAR99", "ABMAR02", "ABDEC03", etc. How to convert for example, "ABMAR99" to the first wednesday in March 1999, which is, "1999-03-03"? 2. Suppose other than rows like "ABMAR99", "ABMAR02", "ABDEC03", I also have rows like "AB_MLTE", "ABMAR2C0",etc, and I only want to keep the rows in the format ("ABMAR99", "ABMAR02", "ABDEC03"). In other words: (1) I only want to keep rows with the exact length of 7. (2) For rows with the exact length of 7, I want to delete rows whose third letter is "_". Thanks a lot, appreciate your help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to convert string to date | Excel Worksheet Functions | |||
convert string to date | Excel Worksheet Functions | |||
Convert Date to STring | Excel Discussion (Misc queries) | |||
Convert rows into 1 cell or 1 string | Excel Worksheet Functions | |||
How to convert string to a date | Excel Worksheet Functions |