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.