Here is what you can do based on your spreadsheet:
1) Fix the formula of B1 to "=Right(A1,3)"
2) Fix the formula of E1 to "=Left(B1,1)"
3) In G1 type: "=value(E1)+value(F1)"
Here is what you can do based on your spreadsheet:
1) Fix the formula of B1 to "=Right(A1,3)"
2) Fix the formula of E1 to "=Left(B1,1)"
3) In G1 type: "=value(E1)+value(F1)"
Draconi
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks