Hello All
Could use some help with the trim function ( I think)
Attached you will find a data set that was imported with the < symbol and the text "min" in columns C and D. I wish to drop the < sign and the word "min" from every cell that contains these criteria in columns C and D and place the values in their respective columns of E and F so that I may total the time in Column G. You will see that I am using the TRIM function to drop the "min" text but dont know how to drop the < symbol when it is present in the column.
Any help is appreciated.
Thanks in advance
Ron
Bookmarks