Hi all,
The problem i require some assitance with is this.
I have a column of numerical identifiers.
Each identifier has 6, 7 or 8 digits, which are then followed by three more numbers puncuated with decimal points i.e.
100001.1.1.1
100001.1.2.1
100001.1.2.2
1000002.1.1.2
1000002.1.1.3
1000002.1.2.1
etc...
I am looking for a way of removing the last 'decimal point' and number from each identifier. I do not mean deleting and replacing original, I only want to create a copy in a following column without the additional number.
Currently i am using the process of Text to Columns,Delimited,Other -Decimal Point. Then using the '&' function in a formula to reconnect the first two 'decimal points' and their adjacent numbers back to the first string of adjacent numbers.
The end product i require from the list of numbers above is as follows
100001.1.1
100001.1.2
100001.1.2
1000002.1.1
1000002.1.1
1000002.1.2
If anyone can help me with this, I would be most obliged.
regards,
Rob
The problem i require some assitance with is this.
I have a column of numerical identifiers.
Each identifier has 6, 7 or 8 digits, which are then followed by three more numbers puncuated with decimal points i.e.
100001.1.1.1
100001.1.2.1
100001.1.2.2
1000002.1.1.2
1000002.1.1.3
1000002.1.2.1
etc...
I am looking for a way of removing the last 'decimal point' and number from each identifier. I do not mean deleting and replacing original, I only want to create a copy in a following column without the additional number.
Currently i am using the process of Text to Columns,Delimited,Other -Decimal Point. Then using the '&' function in a formula to reconnect the first two 'decimal points' and their adjacent numbers back to the first string of adjacent numbers.
The end product i require from the list of numbers above is as follows
100001.1.1
100001.1.2
100001.1.2
1000002.1.1
1000002.1.1
1000002.1.2
If anyone can help me with this, I would be most obliged.
regards,
Rob
Last edited: