formula to replace cell with over 8 characters with word LAN

[Calop]

Hello Group,
I hope someone will be able to help. I need a formula that can check each
cell in column "D" and if it has over 8 characters in the cell, return a
value of the word LAN in column "F". Anything with 8 or under should remain
as is. There will be up to 600 row entries in column "D".
example of col: 799Z
777X
79BM
08/30/06(An)
08/30/06(Put)
08/30/06(InT)
76CC
I'm aware that with all the talent and expertise in the group, this is small
potato's, but it is greatly appreciated.
Thank you,
Calop

 

[Jim Cone]

?...
=IF(LEN(D5)>8,"Lan","")
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


"Calop" <[email protected]>
wrote in message
Hello Group,
I hope someone will be able to help. I need a formula that can check each
cell in column "D" and if it has over 8 characters in the cell, return a
value of the word LAN in column "F". Anything with 8 or under should remain
as is. There will be up to 600 row entries in column "D".
example of col: 799Z
777X
79BM
08/30/06(An)
08/30/06(Put)
08/30/06(InT)
76CC
I'm aware that with all the talent and expertise in the group, this is small
potato's, but it is greatly appreciated.
Thank you,
Calop

 

[Calop]

Jim,
Thank you very much for the formula. It does exactly what I need.
Calop