+ Reply to Thread
Results 1 to 2 of 2

gaps in text converting to new lines

  1. #1
    Registered User
    Join Date
    12-03-2008
    Location
    UK
    Posts
    22

    Question gaps in text converting to new lines

    Hi all

    I am a relatively new excel user and have a problem with text in a cell not converting in tab delimited format how I want it to.
    I am trying to upload a date feed to a site and have received an error report as follows-

    "The text file you have uploaded has some errors. The problem is that some fields mainly product description spread on multiple rows.
    You need to check and make sure that you remove the new line characters (\n) from every field before displaying the value of that field.
    "

    I receive an excel products list from my supplier which has price,barcodes,sku's and product descriptions etc
    I have attached an example, when opened in word or notepad it looks fine when opened in excel that is where the problem is

    The product descriptions are contained in 1 cell and vary in length, when I edit this list to my preference and convert to tab delimited format for upload the product description is spread over many cells !
    How can I resolve this without manually editing the gaps out of each product description?


    I hope this makes sense to you

    Thanks in advance
    Peter


    www.ace-sales.co.uk
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor Richard Schollar's Avatar
    Join Date
    05-23-2006
    Location
    Hampshire UK
    MS-Off Ver
    Excel 2002
    Posts
    1,264
    Hi

    Before you save it down as a text file (ie while still in Excel) I would select the column/Cells where this probelm resides and go Edit>Replace (from the menu bar) or press Ctrl+H if on xl2007, and in the Find box hold down the Alt key and press 010 in sequence from the numeric keypad. Leave the Replace box empty and click Replace All. Do exactly the same again, but this time hold Alt and type in 013 and click Replace All. This will get rid of all Linefeeds/Carriage Returns in your cell. You can then save down as your text file and see if it will now import successfully.

    Richard
    Richard Schollar
    Microsoft MVP - Excel

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1