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
|