View original (French)

Adding a character to a string (excel)

Solved
petithomme8 Posted messages 2 Status Membre -  
petithomme8 Posted messages 2 Status Membre -
Hello,

I extracted the MAC address data from the HPWebJetAdmin tool, but the addresses are truncated without their ":" characters.
I would like to use Excel (or something else, in fact...) to restore these ":".
So I have strings like:
001B78F3C99B
that I want to transform into:
00:1B:78:F3:C9:9B

Thank you in advance for your help :)

<config>Windows XP Firefox 3.5.3</config>

4 réponses

Réponse 1 / 4
f894009 Posted messages 17417 Registration date   Status Membre Last intervention   1 717
 
Hello,

Excel formula to put in a cell: B2 to be replaced by your starting cell

=CONCATENATE(LEFT(B2,2), ":" ,MID(B2,3,2), ":" ,MID(B2,5,2), ":" ,MID(B2,7,2), ":" ,MID(B2,9,2), ":" ,RIGHT(B2,2))

Have a good day
3