Quote:
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.
|
Awesome! Thanks much!
Quote:
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.
|
I will definitely check that out. Thanks!