Removing and Replacing the enter character

  • Thread starter Thread starter Max
  • Start date Start date
M

Max

Hi,
I am trying to cut and paste multi line text descriptions of items
into a single cell in excel 2000 for a website design. If I paste them
directly into the formula bar the description will show up in one cell.
However, my problem is that the import cannot take place if there is an
enter character present within the description line. How would I remove
the enter characters and replace them with a space or a comma space.
Thanks in advance,
Max
 
I am trying to cut and paste multi line text descriptions of items
into a single cell in excel 2000 for a website design. If I paste them
directly into the formula bar the description will show up in one cell.
However, my problem is that the import cannot take place if there is an
enter character present within the description line. How would I remove
the enter characters and replace them with a space or a comma space.
Click to expand...

I don't believe you can do this directly. It'd be possible to automate this with
some programming, but I'd need very precise and complete details about the web
pages and what you're pulling from them.

More expedient may be to paste into NotePad, remove the newline characters, save
as a text file, then open the text file in Excel and reformat as needed.
 
Thanks for the reply. Heres more info. I am designing a website and on
the website I need Item descriptions so I am pulling the item
descriptions from the manufacturer websites. I.E.
Item name: Chcolate Ave. Fudge
Item description:
#10 Can filled with
7.75 lbs. of Hershey's Chocolate Avenue Fudge
6 cans/case. (from the website)

Now if you take this exact product description and cut and paste the
info into one cell you are forced to use the formula line which will
paste in the enter character that isn't recognized by html. The
software I'm using is OScommerce.

My only thoughts is there may be a formula for find and replace that I
can enter the char number of the enter character and have it find and
replace the enter character with " " or space comma.

Any thoughts?

Max
 
Max said:
My only thoughts is there may be a formula for find and replace that I
can enter the char number of the enter character and have it find and
replace the enter character with " " or space comma.
Click to expand...

If you enter such a description into cell X99, you could try

=SUBSTITUTE(X99,CHAR(13)," ")
 
Back
Top