truncating a colum to 55 characters

sparkroms · Jul 8, 2005

Im making some ebay listings so I need to make all titles 55 character
or less. How Would one go about this? I cant seem to find the Truncat
function in excel is there even one

KL · Jul 9, 2005

How about: =RIGHT(A1,55)

Regards,
KL

KL · Jul 9, 2005

Opps! correction:

=LEFT(A1,55)

KL

KL said:
How about: =RIGHT(A1,55)

Regards,
KL

Bryan Hessey · Jul 9, 2005

You could try a helper column which had

=Left(A1,55

truncating a colum to 55 characters

sparkroms

KL

KL

Bryan Hessey