Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to create a variable column in cell reference | Excel Worksheet Functions | |||
How can I get a cell locked if the condition is false? | Excel Worksheet Functions | |||
Can a Formula in Cell X modify Cell Y? | Excel Discussion (Misc queries) | |||
inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
VLookup resulting in a blank cell... | Excel Worksheet Functions |