Hi,
This must be a common issue. I'd like to replace/remove the LineFeed character (a type of square) in an Excel file. How can I do that?
Cheers
Hi,
This must be a common issue. I'd like to replace/remove the LineFeed character (a type of square) in an Excel file. How can I do that?
Cheers
Go to Edit|Replace
In the Find What: hold the Alt key down and type 010 with the number pad of the keyboard
leave the Replace With field empty.
Click Replace All.
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Thank you!
I can now find/replace the lineFeed character. That's fine...
However, my cells squeezed because there is no lineFeed character left, but the squares are still here! I suppose when I opened my DBF file initially, the squares indicates where the lineFeed occurs but are not actually the lineFeed characters.
Then, there must be another combination of character such as ALT+number to Find/Replace the squares?
maybe it's 013?
One way to figure out the code is to use a formula such as the following
=Code(Mid(A1,3,1)) where A1 contains the square somewhere in the cell and 3 is the position within the text string that the character appears...
use the code that is returned... if it is a 2-digit code, then precede with a 0.
Hummm! The code doesn't work... The CODE function is ok on its own and it returns the numeric code of the first character of the string. But when you nest the MID function, it doesn't work!
I don't see how it won't work....
Does the Mid() function on it's own return the character?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks