reduce # of charachters in same cell

M

mortym

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
 
B

Barb R.

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.
 
Top