Hi
I would like to use a function or formula that would take the first 6
characters (combo of alpha & numeric) and copy them into an adjacent column.
This is to be able to set up a filter and/or pivot table
Anne