Delimit across multiple columns

E

eidde1

Hi
I am interested if a macro exists that will delimit across multiple columns in Excel. My data is as follows and I wish to split the antibiotic from the letter which is 23 characters from the beginning of the column. An example of the data is as follows.

Thanks in advance
Eddie
 
Top