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
 Date formula in excel dd/mm/yyyy  Guide
 Excel grade formula  Guide
 Number to words in excel formula  Guide
 Credit summation formula  Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
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