reduce # of charachters in same cell
 

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

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.

"mortym" wrote:

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