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.