Once you isolate the 'client responded' cells, you can then remove any letters and be left with the numbers. Besides the formulas, you can perform a go to search and copy all the cells at once with the value you are looking for. There are many ways to do this, but they are all hack jobs since the source of the data is basically organized very poorly.
As other people mentioned, free form text fields are bad. It is better to create three columns: Client Responded (Y/N), Contacted Client (ddmmyyyy), Client Responded (hh24:mm).
|