=LEFT(cell,6)


--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"Anne903" wrote:

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