Autofill question

[darksides]

Hi,

I'm trying to do this

Please Login or Register  to view this content.

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

Thanks

[Die_Another_Day]

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