This can be done without code:
B1 = "=If(C1 = "","",If(Left(C1,2) = "sw","switch",Left(C1,3))"

HTH

Charles

darksides wrote:
Hi,

I'm trying to do this


Code:
--------------------

---------------------------
| B | C |
|-------------------------|
| vic | vic2fxs | when I write vic2fxs in the C column it autofill B column with vic
| vic | vic2bri | when I write vic2bri in the C column it autofill B column with vic
| vic | vic4fxs | when I write vic4fxs in the C column it autofill B column with vic
| wic | wic1-enet | when I write wic-1-enet in the C column it autofill B column with wic
| switch | sw2950 | when I write sw2950 in the C column it autofill B column with switch
---------------------------

--------------------


Help me to resolve this question...and sorry for my english

Thanks


--
darksides
------------------------------------------------------------------------
darksides's Profile: http://www.excelforum.com/member.php...o&userid=37595
View this thread: http://www.excelforum.com/showthread...hreadid=572211