Formula with @ in cell
Closed
judy
-
Apr 13, 2015 at 08:06 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Apr 14, 2015 at 12:04 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Apr 14, 2015 at 12:04 PM
Related:
- Formula with @ in cell
- Number to words in excel formula - Guide
- Date formula in excel dd/mm/yyyy - Guide
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Excel grade formula - Guide
- Cardtext formula in word - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Apr 14, 2015 at 12:04 PM
Apr 14, 2015 at 12:04 PM
Hi Judy,
Not sure what it exactly is you are looking for, but if you want to add
D4: 8 @ 2000 with D6: 9 @ 2000 to get a result of 17 then the following formula will do the job:
=SUM(LEFT(D4,SEARCH(" ",D4)-1),LEFT(D6,SEARCH(" ",D6)-1))
Please clarify you query if this is not the answer you were hoping for.
Best regards,
Trowa
Not sure what it exactly is you are looking for, but if you want to add
D4: 8 @ 2000 with D6: 9 @ 2000 to get a result of 17 then the following formula will do the job:
=SUM(LEFT(D4,SEARCH(" ",D4)-1),LEFT(D6,SEARCH(" ",D6)-1))
Please clarify you query if this is not the answer you were hoping for.
Best regards,
Trowa