Separating text using Flash fill which came out after 2013. Enter one of the pieces of data you wish to extract, fill down as normal now select the AutoFill options smart tag below and select Flash Fill. Virtual Classroom and Face to face Customised Microsoft Office Computer courses available in Sydney Australia. https://azsolutions.com.au