Separate characters in a string

Hi,

I would like to convert this string ---> FastEthernet0/1/0 to FastEthernet 0 1 0

Can anybody suggest a formula to do this?

Any help will be appreciated

We'll try the easiest first...if it is always going to be FastEthernet0/1/0
replaced with FastEthernet 0 1 0 then I would simply hit Cntrl H
(Find/Replace) and type the two variables in.

If this was just an example and the variables will change then I'd have to
think about it...

"viadisky" wrote:

>
> Hi,
>
> I would like to convert this string ---> FastEthernet0/1/0 to
> FastEthernet 0 1 0
>
> Can anybody suggest a formula to do this?
>
> Any help will be appreciated
>
>
> --
> viadisky
> ------------------------------------------------------------------------
> viadisky's Profile: http://www.excelforum.com/member.php...o&userid=31057
> View this thread: http://www.excelforum.com/showthread...hreadid=507315
>
>