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?

You could try a helper column which had

=Left(A1,55)

How about: =RIGHT(A1,55)

Regards,
KL


"sparkroms" <[email protected]> wrote
in message news:[email protected]...
>
> 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" <[email protected]> wrote in message
news:[email protected]...
> How about: =RIGHT(A1,55)
>
> Regards,
> KL
>
>
> "sparkroms" <[email protected]> wrote
> in message news:[email protected]...
>>
>> 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
>>
>
>