I have a column of cells that contain fuel quantities and prices. The data is entered in gallons, then an ampersand (@), then the price per gallon. Examples:
60.5 @ 5.25
60.5 @ $5.25
60 @ 5.25
I created a series of formulas to extract the gallons and price separately. This part works fine.
My problem is that sometimes the numerical data in the cell is preceded by a location (text). Examples:
Santa Ana 60.5 @ 5.25
Hillsboro 25 @ $4.89
70.5 @ $5.95
I need a way to remove the text characters, if there are any.
Bookmarks