How about: =RIGHT(A1,55)

Regards,
KL


"sparkroms" wrote
in message ...

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


--
sparkroms
------------------------------------------------------------------------
sparkroms's Profile:
http://www.excelforum.com/member.php...o&userid=25037
View this thread: http://www.excelforum.com/showthread...hreadid=385765