Originally Posted by Nepenthes

Yes, there are a couple ways about it.

You can get the eight left characters in a cell by using the formula =left(cell with data,8).

You can also go to Data, Text-to-Columns to split the text into two columns using the fixed-width option.

Originally Posted by dlish

thanks a pretty cool trick Nep!

theres a guy online called The Excel Addict who send out weekly newsletters to his subscribers with free tips for excel. You may want to consider joining his list if you want to brush up on your excel skills. Ive been a part of it for about a year now and ive picked up many cool tricks.