Mega Code Archive

 

Categories / MSOfficeExcel 2007 Tutorial / Text Functions

 

Returns the first nine characters plus an ellipsis for longer string

Input the formula: =IF(LEN(A1)>10,LEFT(A1,9)&"...",A1)