Hello all,
I need a hand creating a formula that will take the 2nd word/number/code in a text which has "-" seperating each word/number/code.
For example, in cell A1, there would be the text "EC12345-TASK01-TESTA"
I would then want cell B1 to *** out "TASK01" only
I originally used the "text to columns" menu option to separate the text and just delete the columns I didn't need. However, I've been told dumb down (i.e. remove extra steps) the sheet so that as soon as the original text is entered in one column, the 2nd word/number/code in each string is shown in the next column.
I've attached an example sheet with some dummy data. column A shows the text and column B should show the 2nd word/number/code (first row has been down as an example of the result expected).
P.S > I have Excel 2010
Regards
Nic
Bookmarks