The following line (below) appears in an Excel spreadsheet. I need to copy the codes (A code and L code) from this column and place them into separate columns within the same sheet. I am exporting from a billing program and then need the codes in their own columns in order to import into another program.
"A106 Communicate (with client) L330 Depositions"
"A106"...in one column and "L330" in another column within my sheet. Can leave the original column that contains text and codes in the sheet. Is there a formula that would do this for me.