Hi, i would deeply appreaciate your help on the following:
I have a column with cell value aaa.bbbb.cccc and somettimes c's are missing and a's and b's are not always 4 characters.
What i would like is to seperate these values in the next columns, using the dot
(If my A1 cell contains aa.bbb.cccc i would like to split it as follows: aa in B1, bbb in C1, cccc in D1 etc.)
I could not use the left/right functions as the number of characters is not static.The good thing is that the delimeter is always a dot.
Thank you in advance