Text length

T

Traci P.

I have a column containing data anywhere from 5 to 8 characters long. I
would like to copy only the first 5 characters into a new column, for
subtotaling purposes. I seem to remember being able to do this, but have not
been able to figure out how. Can anyone help me with this?
 
C

Conan Kelly

Traci

Asuming that your data is in column A starting at row 2, use this formula in
B2:

=LEFT(A2,5)

Copy/fill down as necessary.

HTH,

Conan
 
Top