Search and replace character with <alt+enter> in excell cell

J

JRR

I am converting data from another application into Excel. There are certain
characters (representing ASCII 253) that need to be replaced with the value
of <alt+enter> which is the internal newline + carriage return for data
within a single cell of a sheet. I cannot get the replace function to take
the new value. Who has any suggestions about this?
 
R

RagDyer

In the "Replace With" box, enter:
<Alt> 010
Using the numbers from the Num keypad, *not* the numbers under the function
keys.

Of course, you *will not* see anything in the box after you enter the code,
BUT, don't forget, line feeds aren't visible!
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top