Good day.I need help to extract certain texts in column A to place to columns B,C and D as in the attached file. Those are the ID, azimuth and distance generated by CAD lisp. I did the first three manually but i see a formula in columns B,C and D does best. Thank you ExcelBanter