Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I've opened a text-file in Excel.
Some of the cells contain a "weird" character that looks like a square box. The "weird" character follow the last "normal" character in the cell. For example, a cell contains "normal" characters like: MARSALLA LAVON and the "weird" character follows LAVON I've posted the cell's contents here but this is what results: "MARSALLA LAVON " Since MARSALLA here looks like it's preceded by a double-quote and LAVON here looks like it's followed by a double-quote, I've tried replacing the double-quotes with nothing (i.e., "") but Excel can't find the data I'm searching for. How do I delete or replace the "weird characters"? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Add the same character(s) to multiple cells in a column (or row) . | Excel Discussion (Misc queries) | |||
copy select characters from specified cells. | Excel Worksheet Functions | |||
Why do I get repetitions of characters in my cells? | Excel Discussion (Misc queries) | |||
find cells that contain specific characters | Excel Worksheet Functions | |||
linking cells in Excel 2003. How to not truncate to 255 characters. | Excel Discussion (Misc queries) |