mardi 31 mars 2015

Breaking a string into different columns based on a character

I'm trying to break my string in MS Excel into different columns based on unique identifier, i.e. "."


I need to break the below string,



1.1.4.1.10.3


Formulae should give me below shown results in 6 different columns,



1 1 4 1 10 3


Would really appreciate any kind of help!! Thanks in advance.


Aucun commentaire:

Enregistrer un commentaire