Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to Extract the date or text from the whole column
I want to extract the text or date from the whole column like more than 1136
column. ineed to extarct the a single word like Verify or Clarify from a sentence in the column Thanks Regards Arunkumar |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to Extract the date or text from the whole column
Would you be able to provide few examples..
-- If this post helps click Yes --------------- Jacob Skaria "Arun.fpg" wrote: I want to extract the text or date from the whole column like more than 1136 column. ineed to extarct the a single word like Verify or Clarify from a sentence in the column Thanks Regards Arunkumar |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to Extract the date or text from the whole column
Order has already been entered for dos 01/02/09,02/04/09,0310/09-04/07/09
Dt not recvd for this patient. Hence order & rx not created. Dt recvd for 09/23/08 dos. Since system date is 09/29/08. Order & rx not created. Dt recvd for 02/07/08 dos. Since system date is 02/08/08. Order & rx not created. Dt recvd for 03/11/09 dos. Since system date is 03/12/09. Order & rx entered. Product given as "Conc" & "a/s vision air". Hence took product as E1390 and "Airstep free style". Please clarify whether correct action has been taken or not. Hence order & rx not confimed. Dt recvd for 11/20/08 dos. Since system date is 11/25/08. Order & rx not created. Dt recvd for 11/04/08 dos. Since system date is 11/5/08. Order & rx not created. Dt recvd for 12/19/08 dos. Since system date is 12/22/08. Order & rx not created. Dt recvd for 2/07/08 dos. Since system date is 02/08/08. Order & rx not created. Dt recvd for 08/01/08 dos. Since system date is 08/08/08. Order & rx not created. "1) Dt recvd for dos 01/09/09. Order has already been confirmed for this dt. Hence order & rx not created. 2) Dt recvd for 02/04/09. Order has already been confirmed for this dt. Hence order & rx not created. However product ""swivel connector"" is not found in the entered Dt. Please clarify. 3) Recvd dt for 03/04/09,Since product is E-tank order & rx not created. 4) Entered dt for 03/11/09 dos. For ""conc"" took as ""E1390"". Please clarify. Hence order & rx not confirmed.Since system date is 03/04/09. 4) Recvd dt for 04/01/09 dos. Since system date is 04/06/09. As well as product is M-6.Hence order & rx not entered." Dt recvd for 04/04/08 dos. Since system date is 04/07/08. Order & rx not entered. Dt recvd for 12/16/08 dos. Since system date is 12/16/08. Order & rx not entered. Recvd dt for 01/05/08 dos. System date is 01/05/09. Kindly clarify whether we can enter the order or not.2) Recvd dt for 02/04/09, sicne products are E& M-6 tank. Order & rx not entered. Recvd dt for 06/24/08 dos. Since system date is 06/24/08. Hence order & rx not created. Recvd dt for 02/06/09 dos. Not sure of the products. Need clarification.Hence order & rx not entered. "Recvd dt for 01/29/09 dos. Order and rx entered. Please clarify whether correct action has been taken or not. Hence order & rx not confirmed. Cmn not confirmed. 2) Order has already been entered for dos 03/10/09." Product is not clear. Hence order & rx not entered. Please clarify. Order and rx entered for dt 01/06/09 dos. Please clarify whether correct action has been taken or not. Hence order and rx not confirmed as well form# taken as 0. Cmn not recvd. Hence cmn not confirmed. Order and rx entered for dt 01/29/09 dos. Order confirmed. Cmn not recvd. Hence cmn not confirmed. Dt recvd for 07/02/08 dos. Since system date is 07/03/08. Hence order & rx not entered. By this example i need extract the exact word or separate the exact word like NOT CREATED. Can you please explain "Jacob Skaria" wrote: Would you be able to provide few examples.. -- If this post helps click Yes --------------- Jacob Skaria "Arun.fpg" wrote: I want to extract the text or date from the whole column like more than 1136 column. ineed to extarct the a single word like Verify or Clarify from a sentence in the column Thanks Regards Arunkumar |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
extract date from text | Excel Worksheet Functions | |||
COUNTIF: 2 criteria: Date Range Column & Text Column | Excel Worksheet Functions | |||
extract date from the most current date | Excel Discussion (Misc queries) | |||
How do I extract a date as text not the 1900 reference number | Excel Discussion (Misc queries) | |||
EXTRACT TEXT FROM A DATE | Excel Worksheet Functions |