Comparing the first x numbers in a cell
Closed
nephetius
-
May 14, 2009 at 09:22 PM
mubashir aziz Posts 190 Registration date Sunday April 12, 2009 Status Member Last seen February 16, 2010 - May 19, 2009 at 03:00 AM
mubashir aziz Posts 190 Registration date Sunday April 12, 2009 Status Member Last seen February 16, 2010 - May 19, 2009 at 03:00 AM
Related:
- Comparing the first x numbers in a cell
- Clear only the formatting from the selected cell (leaving the content) - Guide
- Conditional formatting if cell contains text - Excel Forum
- Count if cell contains number - Excel Forum
- If cell contains date then return value ✓ - Office Software Forum
- Based on the values in cells b77 ✓ - Excel Forum
1 response
mubashir aziz
Posts
190
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
166
May 19, 2009 at 03:00 AM
May 19, 2009 at 03:00 AM
Here is the solution ....... you can enter your calculations there ....... suppose your code is in Cell A1 then by using this formula in B1 or C1 you can pick up first 3 char and then can do your calculations ...
=IF(LEFT(A1,3)="125","Do the calculation",IF(LEFT(A1,3)="164","do the office calculation"))
=IF(LEFT(A1,3)="125","Do the calculation",IF(LEFT(A1,3)="164","do the office calculation"))
