All,
I have a sheet of data in which one of the columns contains case notes followed by a time tracking entry that begins with an asterisk (*) and is followed by decimal time (.3).
So the note would look something like this: Posted email to case *.1
What I need to do is to extract the decimal time entries and put them all in a separate column. There are thousands of notes so it needs to work on a large scale.
Anyone have any ideas? I have tried using the delimiter function but it does not capture the data properly. I'm thinking this may require some code/VBA
Thank you,
Mike
Bookmarks