Formula
Closed
Goutam Goswami
-
Apr 19, 2011 at 07:18 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Apr 19, 2011 at 10:23 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Apr 19, 2011 at 10:23 AM
Related:
- Formula
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Excel grade formula - Guide
- Number to words in excel formula - Guide
- Credit summation formula - Guide
- Date formula in excel dd/mm/yyyy - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Apr 19, 2011 at 10:23 AM
Apr 19, 2011 at 10:23 AM
Hi Goutam Goswami,
Is this paticular case you could use this formula:
=SUM(LEFT(A3,1)+LEFT(A4,2)+LEFT(A5,3))
And then do the same for the right side.
But this won't do if the length of the numbers change.
Personally I would use the text delimiter option under the Data top menu.
This will put the 1, 10 and 100 in column A and 2, 20 and 200 in column B.
Now a simple SUM formula will do.
Can you work with this?
Best regards,
Trowa
Is this paticular case you could use this formula:
=SUM(LEFT(A3,1)+LEFT(A4,2)+LEFT(A5,3))
And then do the same for the right side.
But this won't do if the length of the numbers change.
Personally I would use the text delimiter option under the Data top menu.
This will put the 1, 10 and 100 in column A and 2, 20 and 200 in column B.
Now a simple SUM formula will do.
Can you work with this?
Best regards,
Trowa
