truncating a colum to 55 characters
 

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

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

Opps! correction:

=LEFT(A1,55)

KL


"KL" wrote in message
...
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

You could try a helper column which had

=Left(A1,55)


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