Text String

[tsampson]

How do you create a text string that takes the first 24 charachters of any given cell (including spaces).

Example:A1="This is my first text string in Excel 2003"

I want the string to extract "This is my first text st"

So it takes the first 24 charachters (including spaces) and creates the string

Thanks for your help

 

[nbrcrunch]

look at the LEFT() function.

look at the Help system in Excel for text functions. Several more worth reading about.