Text length

  • Thread starter Thread starter Traci P.
  • Start date Start date
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?
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Getting Text data using the Data - Subtotal feature 1
Conditional SUBTOTAL in XL210 Table 7
Splitting text 11
Pullng data out of string of text 4
Fixed Length, Text Formatted 2
Intentionally truncating text characters 2
Text to columns 3

Back
Top