Hi,
I am trying to pick out the ERAP no.s from a string of data. Which part of the data string it appears is inconsistent. So, i cant use the text to columns function. In my excel sheet ,there is a set of data like i mention afore. Is there a way to still pick out just the ERAP no.s to copy and...