I require a function that will put the last number on each data point into new column

Hello,

Here is the function that I require:

I have a large set of data (non recurring numbers), which have different trial numbers at the end of each data point from 1-4.

So something like this:

asdfg-1
nbvcf-2
rtyui-2
cvbjs-4
oiuyt-3
mnbvc-1
zxcfg-2
piuye-4

I need to take the last number in each data set and put it into a new column. So something like this:

asdfg-1.... 1
nbvcf-2.... 2
rtyui-2..... 2
cvbjs-4.... 4
oiuyt-3.... 3
mnbvc-1.. 1
zxcfg-2.... 2
piuye-4.... 4

I have attached an excel file with the same information.

Hopefully you guys can help me with this!

Thank you!

Well, maybe I did not explain it properply, but C16 should not be in the function. C16-D23 is what C5-D12 should look like AFTER the function is applied to C5-D12 > so the function should use ONLY the data points C5-D12. Also, the data set is VERY large and so I must be able to drag the function down and apply it to all the data points.

I hope this clarifies things.

Never mind your function worked! Thank you!