working with length formula

[wabbleknee]

I am looking at a cells that only contain numbers. (4,5,6, or 7 digits) Any
number that is 6 digits or less, leave as is. IF the number is 7 digits, I
want to remove the right most number i.e. Tx


1234 result = 1234
12345 result = 12345
123456 result = 123456
1234567 result = 123456

 

[Jim Cone]

=IF(LEN(C4) =7,LEFT(C4,6)*1,C4)

--
Jim Cone
Portland, Oregon USA .
http://www.contextures.com/excel-sort-addin.html .
(editorial review of special sort excel add-in (30 ways to sort)



"wabbleknee" <[email protected]>
wrote in message
news:[email protected]...

 

[Michael Bednarek]

I am looking at a cells that only contain numbers. (4,5,6, or 7 digits) Any
number that is 6 digits or less, leave as is. IF the number is 7 digits, I
want to remove the right most number i.e. Tx


1234 result = 1234
12345 result = 12345
123456 result = 123456
1234567 result = 123456

This works for me:
=LEFT(A1,6)

 

[wabbleknee]

Thank you very much guys!

"Michael Bednarek" wrote in message

I am looking at a cells that only contain numbers. (4,5,6, or 7 digits)
Any
number that is 6 digits or less, leave as is. IF the number is 7 digits, I
want to remove the right most number i.e. Tx


1234 result = 1234
12345 result = 12345
123456 result = 123456
1234567 result = 123456

This works for me:
=LEFT(A1,6)