How to truncate text in an array

Hi,

I have a very large text array "txt" that has a lot of various info in it. In cell (1,2) there is the decription of the file that I am analyzing. This description is a lot longer than I care to show. For example, the decription in the cell is "Description 1234567890" and I want to pull the text out of that cell and into another 1x1 array so I can put it in a text box, but truncate down the text to "Description 123". How would I do that?

Thank you.

Answer 1

[dpb]

As

c{1,2}(1:desiredlength)

Look up Multilevel Indexing to Access Parts of Cells in the doc under Cell Arrays in the section on Data Types under Language Fundamentals