#### chemicalhaggis

##### New Member

- Joined
- Mar 31, 2013

- Messages
- 2

I am trying to extract 3 numbers to separate cells, which are outputted into an excel sheet in the form "A / B / C" (where A B and C are 1 or two digit numbers). Due to the spaces between the "/" delimiter I can use the LEFT and RIGHT functions specifying that 2 digits are to be returned but I don't know how to extract the central value as it's position in the string may change depending on whether A and B are one or two digit numbers.

Many thanks for any help.

Example strings

8 / 9 / 10

9 / 10 / 11

10 / 11 / 12