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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Delimiting across multiple columns 4
Problem with SET & REF function 0
Copy addition formula of non-consecutive horizontal cells 2
Text to columns 2
delimit using a formula 2
Copying a formula from multiple workbooks down rows and across col 4
Consolidation Table from Different Excel Tabs with Different Format 1
Sorting Columns with a Formula 1

Top