if is always a "< " in front and a " U" in back
set up a helper column with
=value(left(right(entry,Len(entry)-2),len(entry)-4))
sum this column

"Gerry" wrote:

I continually evaluate data that comes in this form:

<"number" "text" ex. - < 0.3 U

I need a way to obtain the total while keeping the less than symbol and text
in the final result. Please note that the symbol and the text never changes
for a given data set. The data set tends to be upwards of 100 cells.

Any help will be greatly appreciated.

Thank you.