hello fellas, thanks for reading my post.
I normally import .txt files into excel sheet and I would like a formula that will seperate them into three different values as demonstrated in the workbook i attached below.
these are the rules to seperate them:
ones seperated with three dots
20.5023.5020 =20 5023 5020
34.4543.4544= 34 4543 4544
100.2.5= 100 2 5
but ones with four dots
233.25.65.66= 233.25 65 66
4.5.56.9= 4.5 56 9
Waiting for your response,
Thank you.
Bookmarks