Excel Forum



Excel Magic Trick 706: Extract Number From Cell With A Time, A Dash and A Number


See how to use the LEFT, SEARCH and TRIM function to eaxtract numbers from a text string that can then be used in a calculating formula.

Download file: http://people.highline.edu/mgirvin/ExcelIsFun.htm





Got a Question? Ask it Here in the Forum.