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
- Date formula in excel dd/mm/yyyy - Guide
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Number to words in excel formula - Guide
- Based on the values in cells b77:b81, what function can automatically return the value in cell c77? ✓ - Excel Forum
- Excel grade formula - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
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