Hi All,
I posted on this forum a couple of weeks ago, and was amazed with how fast and accurate the answers I received were. Thanks again for that.
Here is my new problem:
I have a column of entries which read the following:
UKT_5_070914
UKT_4.75_070915
UKT_8_071215
UKT_4_070916
UKT_8.75_250817
UKT_5_070318
etc.
I would like to find a formula that returns me in a neighbour column only the number in the middle i.e.
5
4.75
8
etc.,
and another column which displays the numbers at the end:
070914
070915
071215
etc.
How can I do that?
Also, the numbers just above actually represent a date: 070914 = 07/09/14. Is there a way to tell excel to convert them in dates?
Any help on these two tasks is most welcome, thanks to all in advance for your help!
Andrea
Bookmarks