Identifying the presence of a randomly ordered text string in a cell

A

AG

Hi All,

I am facing a challenge where I need to do certain computations based
on text that is entered by the users manually. There is a series of
cells in one column containing user narrative. In those narratives
users put a code, such as, "ABC" and their comment and also a date.
Please see the below examples:

ABC to be chased 03 SEP 09
To be analyzed ABC John 3SEP09
ABC Amended Ross 03/SEP/09
etc.

The date mentioned in the above cells can be anything and user enters
them in their own chosen formats as shown above. I need to count all
the cells that contain the text string "ABC" and a particular date, 03
SEP 09 in this case. The string ABC can appear anywhere in the cell
and the date can also appear anywhere. Plus the users choose their own
format to enter the dates.

One of the ways is to advise the users to enter the narrative in a pre-
defined format but right now I have a challenge where I need to
analyze 1000s of rows containing such narratives. Can anyone help me
on this?
 
S

Shane Devenshire

To do this you will need to tell us all possible ways the dates could be
entered since some of the ones you are showing us are not Excel legal dates?
 
A

AG

Hi,
thanks for your reply. None of the date formats that I am going to get
in the narratives will be excel date formats as they always appear in
the middle or end of a text string. The possible ways I can think of
right now are as below:
03 Sep 09
3 Sep 09
03Sep09
3Sep09
3/Sep/09
03/Sep/09

those are the formats I have noticed as entered by the users.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top