Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a cell (A1) that could contain one of two types of data:
1) Passport Number which is in the format of "PXXXXX" where X = numeric digits. 2) a standard ID number which has the format "YYMMDD XXXX XX X" where the first 6 digits represent the persons birth date. I need a formula that will look into the data entered into A1, and: If the entered data is in the format of the Passport Number, do nothing. If the entered data is in the format of the id number, extract the day and month of the persons birthdate and place that data in B1, with the format '15 Feb" - not showing the year value. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Converting Negative Number to Postive number | Excel Worksheet Functions | |||
Identification of what day it is | Excel Worksheet Functions | |||
Converting a negative number to a positive number | Excel Discussion (Misc queries) | |||
Eliminate digits in a product identification number | Excel Discussion (Misc queries) | |||
converting number string to number with decimal | Excel Worksheet Functions |