Applying Vlookup on cell characteristic

[earthworm]

Guys i have a data

in colum A i have random 11 digit numbers
and in same colum i have random 16 digit numbers
all mix together so i dont know what to do

i am thinking of applying pivot but for that i want someone to tell me the formula.


like =if the vaalue of cell a1 contains 11 digit number then if the value is true then "11 Digit Data", if the value is false then "16 digit data" this i want on the cell to be appear . how will i input this command

i want to apply vlookup / lookup and if formula as well

[shg]

=len(a1) & " digits"

[earthworm]

=len(a1) & " digits"

wow thanks .

ok suppose i want to pick only 3-5 digits from whole numbers how to do that

the numbers will vary in length .

like some have 16 , some have 9 ,

but the starting 4-5 digits are unique so i want to pick only staring 4-5 digit count out of total number

example

3245643843215678 ( 324564) is unique
5443567554344 ( 54435) is unique
34534545235 (34534) is unique

i know i can use the formula of =left() but i want to use the len to show selected digit count only

[darkyam]

i know i can use the formula of =left() but i want to use the len to show selected digit count only

I'm not exactly sure what this part means. What do you want to the result of the formula to be? Do you want to determine if the number is 11 digits and then show 5 (the number of digits that make it unique) or 6 if it's 16 digits long? Something else?

[earthworm]

I'm not exactly sure what this part means. What do you want to the result of the formula to be? Do you want to determine if the number is 11 digits and then show 5 (the number of digits that make it unique) or 6 if it's 16 digits long? Something else?

i set limit that if the digit is 16 then pick starting 3 or 15 then pick first 4 digit and so on...

[darkyam]

Perhaps =LEFT(A1,19-LEN(A1))