I have a cell like so , "7.35+.094", is there anyway I can parse this cell with a formula to get "7.35". I dont want to use text to columns, I want to do it within one formula.
My current cell A1 =
=Sheet2!A56 which is "7.35+.094", How can I alter this formula to get "7.35"
Any help would be appreciated.