I just found it: =LEFT(A1, 8)





"Mike Mike" wrote in message
m...
I need to copy the first 8 characters from one cell to another like this:

lampshades
cheapcars
fluffybunny

will be

lampshad
cheapcar
fluffybu

Regards
Mike