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

Hello, I am trying to get a formula to read a 9 to 10 digit number in a cell to determine where to apply the formula results.

ie... the first 3 digits of a 9 to 10 digit code specifies which dept to appply the data that follows in that row

like this..... 125xxxxxxx would be matched to shipping 3expenses, 164xxxxxxx would be for office supplies and so on..

I want to check the first 3 numbers only as they are the "important ones in this particular case.....?

please help if you can

Thanks!

Comparing the first x numbers in a cell
Insert the current date and time in cell a1 ✓ - Excel Forum
Excel conditional formatting if another cell contains specific text ✓ - Excel Forum
Clear only the formatting from the selected cell (leaving the content) - Guide
Which key is used to make multiple line in a single cell - Guide
If cell contains text then return value multiple conditions ✓ - Excel Forum

1 response

Answer 1 / 1

mubashir aziz Posts 190 Registration date Sunday April 12, 2009 Status Member Last seen February 16, 2010 165
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"))

Similar discussions

help me to add particular cells

Comparing columns and returning value

Counting cells containing only numbers

If a cell contains any text then add a value

Formula to Find&replace blank cells in excel

Similar discussions

Subscribe To Our Newsletter!