reduce # of charachters in same cell

G

Guest

Spreadsheet with cells containing >255 charachters. Is there a way to create
something to look at all cells in a column and keep the first 250 in the same
cell?


thanks
 
G

Guest

You can use the LEFT function to get that
Use something like this:

=LEFT(A1,250)

where A1 is the cell identifier and 250 is the number of characters to read.
There may be a limitation on the # of characters in a cell, but I'm not
sure what it is.
 

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

formula based on first two charachters of a cell 3
Alpha Charachters in Format Cells Custom 3
formula for counting charachters in a cell ? 4
Number of Charachters in a cell 3
Return Each Last Non-blank Cell, Value 2 Column Offset, Many GAPS 1
what happened to the Auto Text option 4
Number of Characters 3
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0

Top