eBay
  • Daily Deals
  • Sell
  • Customer Support
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
Please use plain text.
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
Please use plain text.
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.
Please use plain text.
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
Please use plain text.
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'])
Please use plain text.
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.
Please use plain text.
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
Please use plain text.
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
Please use plain text.