Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to replace an unrecognised character
I am importing data to Excel from a flat file - and the rows being imported
contain carraige returns. I can not remove these in the MS excel import process and these then appear in the EXcel celss as what I believe is an unrecognised character symbol - a ? inside a square. I need to separate the contents of these celss based on this symbol but I have not found a solution to do this. of the Text function I can use Clean to remove the symbol but I then lose the ability to separate the contents at the correect position. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Character search and replace | Excel Worksheet Functions | |||
Replace nonprinting character | Excel Worksheet Functions | |||
replace new line character | Excel Discussion (Misc queries) | |||
How do I replace a BEL Character of 7 with a space | Excel Discussion (Misc queries) | |||
How do I replace a character with another? | Excel Discussion (Misc queries) |