Quote:
Originally Posted by Spencer101
Hi,
Have a look at the attached.
On the proviso that all of your data follows the same format this should work.
It doesn't matter how many characters are in each cell, just that they end in " - ETA: MM/DD/YY" i.e. 16 characters.
There are other ways where you can get Excel to ignore characters after a certain point, i.e. anything after " - ETA:" but if your data is pretty uniform then the formula above is probably the easiest.
Let me know if this works for you.
|
Here's a better example.
After re-reading your original post, it would appear that the ETD: etc. part of the data is only there sometimes. This version will extract that leaving only the rest when it DOES appear and will leave the text intact when it DOESN'T appear.
Hope that's of help.