Recent content by shantigal

Thank you very much... :D

It works perfectly well... I had to removed the auto filter before that though... Thank you ! :D

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...

hi, I am trying to pick out the ERAP no.s out of a whole string of data. ERAP no.s are like invoice no.s. Do I Append or Make table? How do i go about doing this? I want the ERAP no. in a row next to the the description field all next to its respective string of data too.... for an...