Excel: extract letters and sum column

Each cell (B1 - B6) is formatted as... =TEXT(8092.58,"#,##0.00 ")& "USD" (i.e. 8092.58 USD) I would like to remove the text (USD) "sum column B. Is there a formula that can remove the text and sum the column? Thank you kindly for helping. Base Salary: 8,092.58 USD Flight Pay: 1,857.14 USD Per Diem: 137.36 USD Housing: 3,571.43 USD Utilities: 91.48 USD Transport: 412.09 USD Total: $0.00

This question generated 14 answers. To proceed to the answers, click here.

This thread is current as of October 18, 2015.

For more resources for Microsoft Excel