In D1, LEFT(C1,5) will return the first five characters in C1.

"klafert" wrote:

I used it before and cant remeber the function command that will allow me to
copy just the 1st 5 numbers in a cell to another cell. Thes cells are like C
& D.

Thanks for your help. Command just slipping my mind.