Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Search and replace character with
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? |
#2
|
|||
|
|||
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! ============================================== "JRR" wrote in message ... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Search and replace | Excel Worksheet Functions | |||
Search and Replace | Excel Discussion (Misc queries) | |||
GLOBAL search and replace | New Users to Excel | |||
Search for a specific character in a cell in an if statement | Excel Worksheet Functions | |||
search & replace | Excel Worksheet Functions |