text cell problem
Posted by tim on July 31, 2001 7:03 AM
I'm trying to find a way to restrict a text cell's length. Specifically I have three columns that I concatenate to produce a fourth column yet when I can't seem to limit the number of characters in a text cell. Here's an example:
A B C D
001 000001 abcdefgh 001-000001-abcdefgh
In column D I'd like to find a way to limit the total number of characters so that my final product looks like this: 001-000001-abc
I'm not sure if I should take column C and edit the data prior to concatenation or if its possible to create a format string that only prints the desired product despite having more text in the cell than is printed.
Any assistance you could offer would be greatly appreciated.