| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Replacing ascii characters
I have imported information from Access where one of the fields contains
manual line breaks. It appears Excel converts the manual line break into a square box. I would like to do a find and replace on these square boxes but am having a hard time figuring out what code to use. I am thinking the ascii code is either 10 or 13 for the mlb. So for the find field what would you type? I have tried CHAR(10) and CHAR(13) but when it searches it says it can't find the data I am searching for. I know I was able to accomplish this a year or so ago but have since forgotten how to do it. Anyone have a suggestion? In general, if you are searching for symbols within an Excel file, how do you indicate the ascii code in the "find what" field? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to replace invalid filename characters | Excel Worksheet Functions | |||
| Replacing specific characters | Excel Discussion (Misc queries) | |||
| Help - Can't directly input Japanese characters into cell | Excel Discussion (Misc queries) | |||
| Replacing specific characters with spaces | Excel Worksheet Functions | |||
| Replacing characters | Excel Worksheet Functions | |||
Threaded Mode
