summing part of cells in a range
hi all,
in the range myRange each cell contains 10 digits, how to sum the first 4
digits to the left of each cell in this myRange, instead of adding each cell
alone like:
=left(A1,4)+left(A2,4)+left(A3,4)+...
thanks for any help
|