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: