eBay
  • Daily Deals
  • Gift Cards
  • Sell
  • Help & Contact
  • Happy Kwanza

eBay Community

THE ANSWER CENTER

The Answer Center is your place to ask fellow eBay Community members questions about buying and selling on eBay, and for you to share your best information, tips, and insights to help other members get answers to their own questions.

View All Questions

Choose a topic to view

Marketing Image for Answer Center Section

GROUPS

Groups is a great place to connect with other community members who share similar interests. Give support, share information, and connect with fellow members. Create or join a Group today!

CHOOSE A GROUP TO VIEW

Marketing image for Groups Section

Announcements

The latest news and updates affecting eBay buyers and sellers

Marketing Image for Announcements Section
Go Now

EBAY COMMUNITY POLICIES

Our policies are designed to create a safe and fair environment for all eBay members. Learning what’s allowed can help you avoid unintentionally breaking the rules and helps everyone in working with reliable, trustworthy members.

Marketing image for eBay Community Policies Section
Go Now
Showing results for 
Search instead for 
Do you mean 

My Profile

Welcome!
PEOPLE YOU FOLLOW

Connect with Fellow eBay Community Members!
Register or Sign In Today!

Reply
Community Member
Posts: 2
Registered: ‎11-23-2003

Can you truncate a text field in Excel ? (title to 55 characters)

In the process of trying to move my Amazon.com book inventory to ebay, I signed up for File Exchange. I've finally opened a (primitive) ebay store, and thought I had it all figured out. Mapped the pertinent information from my open listings report into the File Exchange format, filled out what needed to be filled out, and uploaded a test file. Worked beautifully. Tried with a much larger sample file - big mistake. As it turns out, many of the titles, in the form provided by Amazon.com, with the author listed etc., are more than 55 characters. I am NOT going to individually edit each of these 1000+ plus entried. Is there any way to simply have the Title column truncate text to 55 characters for each entry? Thanks much for any assistance!

Julie
Community Member
Posts: 27
Registered: ‎09-03-2004

Can you truncate a text field in Excel ? (title to 55 characters)

in reply to redladybookstore
You Can Use A Function In Excel To Count The characters
=len(a1) This Will Tell You How Many
Then You Can Sort & Modify The Lines With More Than 55
Have A Graet Day
Community Member
Posts: 6
Registered: ‎07-27-2005

Can you truncate a text field in Excel ? (title to 55 characters)

in reply to redladybookstore
One way to truncate would be to copy the column data to another file..save the file as a text file, then open and reimport the file using "fixed width" option, and cut the column at the 55 mark. Then copy and paste the column back into your spreadsheet.
Community Member
Posts: 27
Registered: ‎09-03-2004

Can you truncate a text field in Excel ? (title to 55 characters)

in reply to redladybookstore
Great Idea
Community Member
Posts: 1
Registered: ‎11-08-2005

Can you truncate a text field in Excel ? (title to 55 characters)

in reply to redladybookstore
If you are creating automated feed with php you can use:

preg_replace("~^(.{1,55})\b.*~", "\\1", $data['product_name'])
Community Member
Posts: 1
Registered: ‎12-11-2007

Can you truncate a text field in Excel ? (title to 55 characters)

in reply to redladybookstore
This is a simple formula

=LEFT(A1,55)

where A1 is the field that you want to be truncated
copy the formula down in its own column to the immediate right of it.

Next, select the column with all formulas, COPY and PASTE SPECIAL (Values).

Done.
Community Member
Posts: 859
Registered: ‎01-30-2006

Can you truncate a text field in Excel ? (title to 55 characters)

in reply to redladybookstore
Another way to do this. Select a cell and click Data>>Then Validation>>>Then Select Text Length, It asks for a Minimum and Maximum Value of Characters for the cell. No Formula.
--------
Chris G
Community Member
Posts: 1
Registered: ‎11-05-2007

Can you truncate a text field in Excel ? (title to 55 characters)

in reply to redladybookstore
1. Insert a new column to the right of the column with too many characters.
2. Select the column you wish to truncate.
3. Data>
4. Text to columns>
5. Fixed width>
6. Click 55> then finish.
7. This moves extra text to the new column you created.
8. Delete this extra column