I am looking for a formula that will look at a text string and identify the last period in a text string and truncate everything to the right of it. I am helping another lounger in the Project forum with this calculation and since Project uses many of the same text manipulation functions as Excel I thought I might try having all of the lounge Excel formula gurus take a look, then I can provide the how to apply in Project information, and of course credit to any contrubuting loungers.
1.1 = 1
1.2.1 = 1.2
1.2.12 = 1.2
18.104.22.168 = 1.2.2
I created: (the name of the field I am working with is WBS)
This works great until I get to 1.2.12 then it stops working because the logic I used in the funcion does not account for this possibility