here's two ideas
1) use data / text to columns
2) use a formula such as =LEFT(A1,3) or =RIGHT(A1,4)

if you'ld like more assistance please post back with additional details and
type out two or three examples of your data.

Cheers
JulieD


"Bootsy" wrote in message
...

--
bootsy