This should get you part of the way.

Enter the following
B1: 1
C1: =B1+1
Copy over to J1

B2: =10^(B1-1)
Copy over to J2
C1: Enter the value you want in this case 1234567

Enter the following in C3:
C3: =MOD($A3/B$2,10*B$2)

Copy over to J3

Does that help??

"BLK" wrote:

There are two ways for me to solve what I'm trying to do:

1) Can excel add numbers within a value? For example if 17 is in a cell, can
I tell excel to add 1+7 and return 8? Or if the value is 325 than excel would
return a '1' (as 3+2+5 = 10 and 1+0=1)

2) Or is there a way for excel to check whether a specific integer is
contained within a value? For example, if the number in the cell is 17, is
there a way for excel to check whether a '7' is contained within the cell and
return a value or word I specify?

Hope that's clear. Thanks.